IDbSpecificCreatorCreateSubQuery Method (IEntityFieldCore, IFieldPersistenceInfo, IPredicate, Int64, ISortExpression, IRelationCollection, IGroupByCollection)

IRetrievalQuery CreateSubQuery(
	IEntityFieldCore[] selectList,
	IFieldPersistenceInfo[] fieldPersistenceInfos,
	IPredicate selectFilter,
	long maxNumberOfItemsToReturn,
	ISortExpression sortClauses,
	IRelationCollection relationsToWalk,
	IGroupByCollection groupByClause
)

Function CreateSubQuery ( 
	selectList As IEntityFieldCore(),
	fieldPersistenceInfos As IFieldPersistenceInfo(),
	selectFilter As IPredicate,
	maxNumberOfItemsToReturn As Long,
	sortClauses As ISortExpression,
	relationsToWalk As IRelationCollection,
	groupByClause As IGroupByCollection
) As IRetrievalQuery

Parameters

selectList

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

fieldPersistenceInfos

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

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.

maxNumberOfItemsToReturn

Type: SystemInt64
The maximum number of items to return with this retrieval query. If the used Dynamic Query Engine supports it, 'TOP' is used to limit the amount of rows to return. When set to 0, no limitations are specified.

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.

groupByClause

Type: SD.LLBLGen.Pro.ORMSupportClassesIGroupByCollection
the group by clause to use

Return Value

Reference