Click or drag to resize
IDbSpecificCreatorCreateSubQuery Method (IEntityFieldCore, IFieldPersistenceInfo, IPredicate, Int64, ISortExpression, IRelationCollection, IGroupByCollection, Boolean)
Creates a new Select Query which is ready to use as a subquery, based on the specified select list and the specified set of relations.

Namespace:  SD.LLBLGen.Pro.ORMSupportClasses
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: (5.3.0)
IRetrievalQuery CreateSubQuery(
	IEntityFieldCore[] selectList,
	IFieldPersistenceInfo[] fieldPersistenceInfos,
	IPredicate selectFilter,
	long maxNumberOfItemsToReturn,
	ISortExpression sortClauses,
	IRelationCollection relationsToWalk,
	IGroupByCollection groupByClause,
	bool allowDuplicates


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: 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: 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.
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: SD.LLBLGen.Pro.ORMSupportClassesIGroupByCollection
the group by clause to use
Type: SystemBoolean
If true, duplicates are allowed, otherwise DISTINCT (if applicable) is emitted.

Return Value

Type: IRetrievalQuery
IRetrievalQuery instance which is ready to be used.
ArgumentNullExceptionWhen selectList is null or fieldsPersistenceInfo is null or relationsToWalk is null
ArgumentExceptionWhen selectList contains no EntityFieldCore instances or fieldsPersistenceInfo is empty.
See Also