Click or drag to resize

SqlServerSpecificCreatorCreateSubQuery 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.DQE.SqlServer
Assembly:  SD.LLBLGen.Pro.DQE.SqlServer (in SD.LLBLGen.Pro.DQE.SqlServer.dll) Version: 5.4.0.0 (5.4.0)
Syntax
Copy
public override IRetrievalQuery CreateSubQuery(
	IEntityFieldCore[] selectList,
	IFieldPersistenceInfo[] fieldPersistenceInfos,
	IPredicate selectFilter,
	long maxNumberOfItemsToReturn,
	ISortExpression sortClauses,
	IRelationCollection relationsToWalk,
	IGroupByCollection groupByClause,
	bool allowDuplicates
)

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
allowDuplicates
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.

Implements

IDbSpecificCreatorCreateSubQuery(IEntityFieldCore, IFieldPersistenceInfo, IPredicate, Int64, ISortExpression, IRelationCollection, IGroupByCollection, Boolean)
Exceptions
ExceptionCondition
ArgumentNullExceptionWhen selectList is null or fieldsPersistenceInfo is null or relationsToWalk is null
ArgumentExceptionWhen selectList contains no EntityFieldCore instances or fieldsPersistenceInfo is empty.
See Also