Click or drag to resize
DynamicQueryEngineBaseCreatePagingSelectDQ Method
Creates a new Select Query which is ready to use, based on the specified select list and the specified set of relations. If selectFilter is set to null, all rows are selected.

Namespace:  SD.LLBLGen.Pro.ORMSupportClasses
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: (5.3.0)
protected virtual IRetrievalQuery CreatePagingSelectDQ(
	IEntityFieldCore[] selectList,
	IFieldPersistenceInfo[] fieldsPersistenceInfo,
	DbConnection connectionToUse,
	IPredicate selectFilter,
	int rowsToSkip,
	int rowsToTake,
	ISortExpression sortClauses,
	IRelationCollection relationsToWalk,
	bool allowDuplicates,
	IGroupByCollection groupByClause


Type: SD.LLBLGen.Pro.ORMSupportClassesIEntityFieldCore
list of IEntityFieldCore objects to select
Type: SD.LLBLGen.Pro.ORMSupportClassesIFieldPersistenceInfo
Array of IFieldPersistenceInfo objects to use to build the select query
Type: System.Data.CommonDbConnection
The connection to use.
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.
Type: SystemInt32
The rows to skip. Default 0
Type: SystemInt32
The rows to take. Default 0, which means all.
Type: SD.LLBLGen.Pro.ORMSupportClassesISortExpression
The order by specifications for the sorting of the resultset. When not specified, no sorting is applied.
Type: SD.LLBLGen.Pro.ORMSupportClassesIRelationCollection
list of EntityRelation objects, which will be used to formulate a FROM clause with INNER JOINs.
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.
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

Type: IRetrievalQuery
ready to use query
ArgumentNullExceptionWhen selectList is null or fieldsPersistenceInfo is null or relationsToWalk is null
ArgumentExceptionWhen selectList contains no EntityFieldCore instances or fieldsPersistenceInfo is empty.
See Also