Click or drag to resize

DynamicQueryEngineManglePageSelectDQ2012 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.4.0.0 (5.4.0)
Syntax
protected virtual void ManglePageSelectDQ2012(
	IRetrievalQuery selectQuery,
	int rowsToSkip,
	int rowsToTake,
	bool orderByPresent
)

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.
orderByPresent
Type: SystemBoolean
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