DynamicQueryEngineBaseCreateRowCountDQ Method |
Creates a select query which will be executed as a scalar, and which will return a single value, the number of rows in the query
formed by the elements passed in.
Namespace: SD.LLBLGen.Pro.ORMSupportClassesAssembly: SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.0.0.0 (5.0.0)
Syntax public virtual IRetrievalQuery CreateRowCountDQ(
IEntityFieldCore[] selectList,
IFieldPersistenceInfo[] fieldsPersistenceInfo,
DbConnection connectionToUse,
IPredicate selectFilter,
IRelationCollection relationsToWalk,
bool allowDuplicates,
IGroupByCollection groupByClause
)
Public Overridable Function CreateRowCountDQ (
selectList As IEntityFieldCore(),
fieldsPersistenceInfo As IFieldPersistenceInfo(),
connectionToUse As DbConnection,
selectFilter As IPredicate,
relationsToWalk As IRelationCollection,
allowDuplicates As Boolean,
groupByClause As IGroupByCollection
) As IRetrievalQuery
Parameters
- selectList
- Type: SD.LLBLGen.Pro.ORMSupportClassesIEntityFieldCore
list of IEntityFieldCore objects to select - fieldsPersistenceInfo
- Type: SD.LLBLGen.Pro.ORMSupportClassesIFieldPersistenceInfo
Array of IFieldPersistenceInfo objects to use to build the select query - connectionToUse
- Type: System.Data.CommonDbConnection
The connection to use for the 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. - relationsToWalk
- Type: SD.LLBLGen.Pro.ORMSupportClassesIRelationCollection
list of EntityRelation objects, which will be used to formulate a FROM clause with INNER JOINs. - allowDuplicates
- 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. - groupByClause
- 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:
IRetrievalQueryIRetrievalQuery instance which is ready to be used.
Exceptions Exception | Condition |
---|
ArgumentNullException | When selectList is null or fieldsPersistenceInfo is null |
ArgumentException | When selectList contains no EntityFieldCore instances or fieldsPersistenceInfo is empty. |
See Also