API Reference
Browse the REDB API documentation. Select a namespace or type from the tree on the left, or click on items below.
Search results for: Count
Clear search
Agg
redb.Core.Query.Aggregation
Count()
Count of records (COUNT(*))
Count<T>(IEnumerable<T>)
Count of elements in a collection
Count<TKey, TProps>(IRedbGrouping<TKey, TProps>)
Count in a group: Agg.Count(g)
AggregateFunction
redb.Core.Query.Aggregation
Count
Record count
ArrayLeafOperator
redb.Core.Query.Filtering
CountEqual
array.Count == N
CountGreater
array.Count > N
CountGreaterOrEqual
array.Count >= N
CountLess
array.Count < N
CountLessOrEqual
array.Count <= N
CacheStatistics
redb.Core.Models.Permissions
ComparisonOperator
redb.Core.Query.QueryExpressions
CompleteSchemeMetadata
redb.Core.Caching
UsageCount
Usage count.
DeletionMark
redb.Core.Services
MarkedCount
Number of objects marked for deletion (including descendants)
Department
redb.Examples.Models
E070_CountAsync
redb.Examples.Examples
E091_TreeCount
redb.Examples.Examples
ExampleResult
redb.Examples.Output
Count
Number of objects processed/found.
FieldStatistics<T>
redb.Core.Query.Aggregation
Count
Record count
IPermissionProvider
redb.Core.Providers
GetPermissionCountAsync()
Get total permission count.
GetRolePermissionCountAsync(IRedbRole)
Get role permission count.
GetUserPermissionCountAsync(IRedbUser)
Get user permission count.
IRedbGroupedQueryable<TKey, TProps>
redb.Core.Query.Grouping
CountAsync()
Returns group count.
IRedbProjectedQueryable<TResult>
redb.Core.Query
CountAsync()
Count results.
IRedbQueryable<TProps>
redb.Core.Query
CountAsync()
Count records without loading data.
IRoleProvider
redb.Core.Providers
GetRoleCountAsync()
Get role count.
GetRoleUserCountAsync(IRedbRole)
Get user count in role.
ISqlDialect
redb.Core.Query
Permissions_Count()
SELECT COUNT of all permissions
Permissions_CountByRole()
SELECT COUNT of permissions by role. Params: $1=roleId
Permissions_CountByUser()
SELECT COUNT of permissions by user. Params: $1=userId
Query_CountTemplate()
SQL template for COUNT query. Params: functionName
Query_TreeCountNormalSql(string)
SQL for tree count query (normal search).
Query_TreeCountWithParentIdsSql(string)
SQL for tree COUNT with parent_ids array.
Roles_Count()
SELECT COUNT of all roles
Users_Count()
SELECT COUNT of all users
Users_CountEnabled()
SELECT COUNT of enabled users
UsersRoles_CountByRole()
SELECT COUNT of users for role. Params: $1=roleId
IUserProvider
redb.Core.Providers
GetActiveUserCountAsync(DateTimeOffset, DateTimeOffset)
Get active user count for period.
GetUserCountAsync(bool)
Get user count.
LicenseInfo
redb.Core.Pro.Licensing
Country
Optional country code (e.g., "RU", "US")
MsSqlDialect
redb.MSSql.Sql
Permissions_Count()
SELECT COUNT of all permissions
Permissions_CountByRole()
SELECT COUNT of permissions by role. Params: $1=roleId
Permissions_CountByUser()
SELECT COUNT of permissions by user. Params: $1=userId
Query_CountTemplate()
MSSQL uses EXEC and OPENJSON for JSON parameters.
Query_TreeCountNormalSql(string)
For Tree procedures, we use temp table to capture EXEC result and extract total_count.
Query_TreeCountWithParentIdsSql(string)
MSSQL: capture EXEC result and extract total_count.
Roles_Count()
SELECT COUNT of all roles
Users_Count()
SELECT COUNT of all users
Users_CountEnabled()
SELECT COUNT of enabled users
UsersRoles_CountByRole()
SELECT COUNT of users for role. Params: $1=roleId
PermissionProviderBase
redb.Core.Providers.Base
GetPermissionCountAsync()
Get total permission count.
GetRolePermissionCountAsync(IRedbRole)
Get role permission count.
GetUserPermissionCountAsync(IRedbUser)
Get user permission count.
GetUserPermissionCountAsync(long)
Get permission count for user.
PlatformResult
redb.Examples.Models
Count
Number of objects processed/found.
PostgreSqlDialect
redb.Postgres.Sql
Permissions_Count()
SELECT COUNT of all permissions
Permissions_CountByRole()
SELECT COUNT of permissions by role. Params: $1=roleId
Permissions_CountByUser()
SELECT COUNT of permissions by user. Params: $1=userId
Query_CountTemplate()
SQL template for COUNT query. Params: functionName
Query_TreeCountNormalSql(string)
SQL for tree count query (normal search).
Query_TreeCountWithParentIdsSql(string)
PostgreSQL: extract total_count from tree function result.
Roles_Count()
SELECT COUNT of all roles
Users_Count()
SELECT COUNT of all users
Users_CountEnabled()
SELECT COUNT of enabled users
UsersRoles_CountByRole()
SELECT COUNT of users for role. Params: $1=roleId
PropertyFunction
redb.Core.Query.QueryExpressions
Count
Collection element count (array.Count)
PropsCacheStatistics
redb.Core.Caching
ProQueryProvider
redb.MSSql.Pro.Query
ExecuteCountAsync<TProps>(QueryContext<TProps>)
Pro Override: COUNT via CTE + JOIN (uses BuildQuerySqlAsync).
ProQueryProvider
redb.Postgres.Pro.Query
ExecuteCountAsync<TProps>(QueryContext<TProps>)
Pro Override: COUNT via CTE + JOIN (uses BuildQuerySqlAsync).
ProTreeQueryProvider
redb.MSSql.Pro.Query
ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>)
⚡ Pro Override: Tree Count via CTE + pvt.
ProTreeQueryProvider
redb.Postgres.Pro.Query
ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>)
⚡ Pro Override: Tree Count via CTE + PVT.
QueryProviderBase
redb.Core.Query.Base
ExecuteCountAsync<TProps>(QueryContext<TProps>)
Executes COUNT query. Override in Pro for PVT-based count with computed expressions.
RedbArrayGroupedQueryable<TKey, TItem, TProps>
redb.Core.Query.Grouping
CountAsync()
Returns group count.
RedbGroupedQueryable<TKey, TProps>
redb.Core.Query.Grouping
CountAsync()
Returns group count.
RedbObjectExtensions
redb.Core.Extensions
GetChildrenCountAsync<T>(IRedbObject, ITreeProvider)
Gets count of object children
GetDescendantsCountAsync<T>(IRedbObject, ITreeProvider, int?)
Gets count of all object descendants
RedbProjectedQueryable<TProps, TResult>
redb.Core.Query
CountAsync()
Count results.
RedbProjectedQueryableTaskExtensions
redb.Core.Query
RedbQueryable<TProps>
redb.Core.Query
BuildCountExpression()
Builds expression for record count
CountAsync()
Count records without loading data.
RedbServiceBase
redb.Core
GetPermissionCountAsync()
Get total permission count.
GetRolePermissionCountAsync(IRedbRole)
Get role permission count.
GetUserPermissionCountAsync(IRedbUser)
Get user permission count.
RoleProviderBase
redb.Core.Providers.Base
GetRoleCountAsync()
Get role count.
GetRoleUserCountAsync(IRedbRole)
Get user count in role.
SchemeCacheStatistics
redb.Core.Caching
CachedSchemesCount
Cached schemes count.
TypeMappingsCount
Type mappings count.
SqlParameterCollector
redb.Core.Pro.Query
Count
Number of added parameters.
SqlParameterCollectorBase
redb.Core.Query.Parameters
Count
Number of parameters added.
StaticCacheStatistics
redb.Core.Caching
StructureCacheStatistics
redb.Core.Caching
TopUsedScheme
redb.Core.Caching
UsageCount
Usage count.
TreeCollection
redb.Core.Models.Collections
Count
Gets count of nodes in collection
TreeCollection<TProps>
redb.Core.Models.Collections
Count
Gets count of nodes in collection
TreeGroupedQueryable<TKey, TProps>
redb.Core.Query.Grouping
CountAsync()
Returns group count.
TreeProjectedQueryable<TProps, TResult>
redb.Core.Query
CountAsync()
Count results.
TreeQueryableBase<TProps>
redb.Core.Query.Base
CountAsync()
Count records without loading data.
TreeQueryProviderBase
redb.Core.Query.Base
ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>)
Execute COUNT for tree query through search_tree_objects_with_facets
TypeCacheStatistics
redb.Core.Caching
TypeMigrationResult
redb.Core.Providers
TypeUsageInfo
redb.Core.Caching
UserCacheStats
redb.Core.Caching
ObjectCount
Number of user objects in cache.
UserProviderBase
redb.Core.Providers.Base
GetActiveUserCountAsync(DateTimeOffset, DateTimeOffset)
Get active user count for period.
GetUserCountAsync(bool)
Get user count.