DynamicQueryEngineBaseCreatePagingSelectDQ Method

protected virtual IRetrievalQuery CreatePagingSelectDQ(
	IEntityFieldCore[] selectList,
	IFieldPersistenceInfo[] fieldsPersistenceInfo,
	DbConnection connectionToUse,
	IPredicate selectFilter,
	int rowsToSkip,
	int rowsToTake,
	ISortExpression sortClauses,
	IRelationCollection relationsToWalk,
	bool allowDuplicates,
	IGroupByCollection groupByClause
)

Protected Overridable Function CreatePagingSelectDQ ( 
	selectList As IEntityFieldCore(),
	fieldsPersistenceInfo As IFieldPersistenceInfo(),
	connectionToUse As DbConnection,
	selectFilter As IPredicate,
	rowsToSkip As Integer,
	rowsToTake As Integer,
	sortClauses As ISortExpression,
	relationsToWalk As IRelationCollection,
	allowDuplicates As Boolean,
	groupByClause As IGroupByCollection
) As IRetrievalQuery

Parameters

selectList

Type: SD.LLBLGen.Pro.ORMSupportClassesIEntityFieldCore
list of IEntityFieldCore objects to select

fieldsPersistenceInfo

Type: SD.LLBLGen.Pro.ORMSupportClassesIFieldPersistenceInfo
Array of IFieldPersistenceInfo objects to use to build the select query

connectionToUse

Type: System.Data.CommonDbConnection
The connection to use.

selectFilter

Type: SD.LLBLGen.Pro.ORMSupportClassesIPredicate
A complete IPredicate implementing object which contains the filter for the rows to select. When set to null, no filtering is done, and all rows are returned.

rowsToSkip

Type: SystemInt32
The rows to skip. Default 0

rowsToTake

Type: SystemInt32
The rows to take. Default 0, which means all.

sortClauses

Type: SD.LLBLGen.Pro.ORMSupportClassesISortExpression
The order by specifications for the sorting of the resultset. When not specified, no sorting is applied.

relationsToWalk

Type: SD.LLBLGen.Pro.ORMSupportClassesIRelationCollection
list of EntityRelation objects, which will be used to formulate a FROM clause with INNER JOINs.

allowDuplicates

Type: SystemBoolean
Flag which forces the inclusion of DISTINCT if set to true. If the resultset contains fields of type ntext, text or image, no duplicate filtering is done.

groupByClause

Type: SD.LLBLGen.Pro.ORMSupportClassesIGroupByCollection
The list of fields to group by on. When not specified or an empty collection is specified, no group by clause is added to the query. A check is performed for each field in the selectList. If a field in the selectList is not present in the groupByClause collection, an exception is thrown.

Return Value

Reference