ForSystemTime for TypedView

Posts   
 
    
Posts: 2
Joined: 31-Aug-2018
# Posted on: 31-Aug-2018 09:06:03   

Hi to all, is there a method like ForSystemTime that I can use with TypedView in Adapter mode for SQL Server 2016?

Thank a lot

LLBLGen Pro v5.4 RTM (5.4.1)

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 31-Aug-2018 12:35:16   

Yes, you can generate a TypedView as a PocoWithLinqQuery (or PocoWithQuerySpecQuery), and use the typed view in a linq query with the ForSystemTime() extension method or in a QuerySpec query with the extension method. See: https://www.llblgen.com/Documentation/5.4/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/gencode_dbspecificfeatures.htm#sql-server-2016-temporal-table-support

To get your typed view generated as a poco with a linq query, use either the setting in the project settings (Entity Model -> LLBLGen Pro Runtime Framework -> TypedViewOutput type default) or open the typedview in its editor and go to the code gen. info tab and set the setting there per typed view.

Frans Bouma | Lead developer LLBLGen Pro
Posts: 2
Joined: 31-Aug-2018
# Posted on: 31-Aug-2018 14:04:43   

Otis wrote:

Yes, you can generate a TypedView as a PocoWithLinqQuery (or PocoWithQuerySpecQuery), and use the typed view in a linq query with the ForSystemTime() extension method or in a QuerySpec query with the extension method. See: https://www.llblgen.com/Documentation/5.4/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/gencode_dbspecificfeatures.htm#sql-server-2016-temporal-table-support

To get your typed view generated as a poco with a linq query, use either the setting in the project settings (Entity Model -> LLBLGen Pro Runtime Framework -> TypedViewOutput type default) or open the typedview in its editor and go to the code gen. info tab and set the setting there per typed view.

Thanks a lot