Click or drag to resize
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.ORMSupportClasses
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: (5.3.0)
public virtual IRetrievalQuery CreateRowCountDQ(
	IEntityFieldCore[] selectList,
	IFieldPersistenceInfo[] fieldsPersistenceInfo,
	DbConnection connectionToUse,
	IPredicate selectFilter,
	IRelationCollection relationsToWalk,
	bool allowDuplicates,
	IGroupByCollection groupByClause


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: System.Data.CommonDbConnection
The connection to use for the 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: SD.LLBLGen.Pro.ORMSupportClassesIRelationCollection
list of EntityRelation objects, which will be used to formulate a FROM clause with INNER JOINs.
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.
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: IRetrievalQuery
IRetrievalQuery instance which is ready to be used.
ArgumentNullExceptionWhen selectList is null or fieldsPersistenceInfo is null
ArgumentExceptionWhen selectList contains no EntityFieldCore instances or fieldsPersistenceInfo is empty.
See Also