IDataAccessAdapterGetDbCount Method (IEntityCollection2, IRelationPredicateBucket) |
Gets the estimated number of objects returned by a query for objects to store in the entity collection passed in, using the filter and
groupby clause specified. The number is estimated as duplicate objects can be present in the plain query results, but will be filtered out
when the query result is transformed into objects.
Namespace:
SD.LLBLGen.Pro.ORMSupportClasses
Assembly:
SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.4.0.0 (5.4.0)
Syntax int GetDbCount(
IEntityCollection2 collection,
IRelationPredicateBucket filter
)
Function GetDbCount (
collection As IEntityCollection2,
filter As IRelationPredicateBucket
) As Integer
Parameters
- collection
- Type: SD.LLBLGen.Pro.ORMSupportClassesIEntityCollection2
EntityCollection instance which will be fetched by the query to get the rowcount for - filter
- Type: SD.LLBLGen.Pro.ORMSupportClassesIRelationPredicateBucket
filter to use by the query to get the rowcount for
Return Value
Type:
Int32the number of rows the query for the fields specified, using the filter, relations and groupbyClause specified.
Remarks This method performs a SELECT COUNT(*) FROM (actual query) and executes that as a scalar query. This construct is not supported on
Firebird. You can try to achieve the same results by using GetScalar and AggregateFunction.CountRow, though those results can differ from
the result returned by GetDbCount if you use a group by clause.
See Also