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.SqlServerAssembly: SD.LLBLGen.Pro.DQE.SqlServer (in SD.LLBLGen.Pro.DQE.SqlServer.dll) Version: 5.0.0.0 (5.0.0)
Syntax public override IRetrievalQuery CreateSubQuery(
IEntityFieldCore[] selectList,
IFieldPersistenceInfo[] fieldPersistenceInfos,
IPredicate selectFilter,
long maxNumberOfItemsToReturn,
ISortExpression sortClauses,
IRelationCollection relationsToWalk,
IGroupByCollection groupByClause,
bool allowDuplicates
)
Public Overrides Function CreateSubQuery (
selectList As IEntityFieldCore(),
fieldPersistenceInfos As IFieldPersistenceInfo(),
selectFilter As IPredicate,
maxNumberOfItemsToReturn As Long,
sortClauses As ISortExpression,
relationsToWalk As IRelationCollection,
groupByClause As IGroupByCollection,
allowDuplicates As Boolean
) 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 - 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 Exception | Condition |
---|
ArgumentNullException | When selectList is null or fieldsPersistenceInfo is null or relationsToWalk is null |
ArgumentException | When selectList contains no EntityFieldCore instances or fieldsPersistenceInfo is empty. |
See Also