Click or drag to resize

DynamicQueryEngineManglePageSelectDQ2012 Method (IRetrievalQuery, Int32, Int32)

Creates a query using OFFSET and FETCH NEXT. For SQL Server 2012 and later.

Namespace:  SD.LLBLGen.Pro.DQE.SqlServer
Assembly:  SD.LLBLGen.Pro.DQE.SqlServer (in SD.LLBLGen.Pro.DQE.SqlServer.dll) Version: 5.8.0.0 (5.8.21.0111)
Syntax
Copy
protected virtual void ManglePageSelectDQ2012(
	IRetrievalQuery selectQuery,
	int rowsToSkip,
	int rowsToTake
)

Parameters

selectQuery
Type: SD.LLBLGen.Pro.ORMSupportClassesIRetrievalQuery
the actual query to page over.
rowsToSkip
Type: SystemInt32
The rows to skip.
rowsToTake
Type: SystemInt32
The rows to take.
Remarks
Query structure: 
            SELECT ...
            FROM ...
            OFFSET rowsToSkip ROWS
            -- if rowsToTake > 0 ->
            FETCH NEXT (rowsToTake) ROWS ONLY
See Also