Click or drag to resize
DynamicQueryEngine.ManglePageSelectDQ2012 Method (IRetrievalQuery, Int32, Int32, Boolean)
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.2.0.0 (5.2.17.0403)
Syntax
Copy
protected virtual void ManglePageSelectDQ2012(
	IRetrievalQuery selectQuery,
	int rowsToSkip,
	int rowsToTake,
	bool orderByPresent
)

Parameters

selectQuery
Type: SD.LLBLGen.Pro.ORMSupportClasses.IRetrievalQuery
the actual query to page over.
rowsToSkip
Type: System.Int32
The rows to skip.
rowsToTake
Type: System.Int32
The rows to take.
orderByPresent
Type: System.Boolean
if set to true there's an order by present in the outer query.
Remarks
Query structure: 
            SELECT ...
            FROM ...
            OFFSET rowsToSkip ROWS
            -- if rowsToTake > 0 ->
            FETCH NEXT (rowsToTake) ROWS ONLY
If no order by is present in the query, orderByPresent is false, and the query engine will append an ORDER BY (SELECT NULL) first before the OFFSET.
See Also