RedBase Documentation

Welcome to the RedBase documentation portal. Browse the API reference, explore code examples, and learn how to build with REDB.

Quick Start Examples

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: Query Clear search
C appExt redb.Core.Utils
M Filter<T>(IQueryable<T>, string, object) Filter IQueryable by property name dynamically.
C CompiledPvtQuery redb.Core.Pro.Query.Models
T CompiledPvtQuery(string, IReadOnlyList<FieldInfo>, string) Compiled PVT query with SQL template and metadata.
C CompiledQuery redb.Core.Query.Models
T CompiledQuery(string, IReadOnlyList<FieldInfo>, string) Compiled SQL query with template and metadata.
C E096_TreeQuery redb.Examples.Examples
C E097_TreeQueryRoots redb.Examples.Examples
C E098_TreeQueryLeaves redb.Examples.Examples
C E099_TreeQueryLevel redb.Examples.Examples
C E105_TreeQueryWithRoot redb.Examples.Examples
C E106_TreeQueryChildrenOf redb.Examples.Examples
C E107_TreeQueryMultiRoot redb.Examples.Examples
C E160_TreeQueryExpressions redb.Examples.Examples
C E173_TreeQueryGroupBy redb.Examples.Examples
C E174_TreeQueryWindow redb.Examples.Examples
C E175_TreeQueryGroupByWindow redb.Examples.Examples
C ExpressionSqlCache redb.Core.Query.Caching
M Set(string, CompiledQuery) Sets cached query.
M TryGet(string, out CompiledQuery?) Tries to get cached query.
C FacetFilterBuilder redb.Core.Query
M BuildQueryParameters(int?, int?) Build query parameters (limit, offset).
C GroupedWindowedQueryable<TKey, TProps> redb.Core.Query.Grouping
T GroupedWindowedQueryable(IRedbQueryProvider, long, Expression, GroupedWindowSpec<TKey, TProps>, FilterExpression?) Constructor with FilterExpression (Pro version).
T GroupedWindowedQueryable(IRedbQueryProvider, long, Expression, GroupedWindowSpec<TKey, TProps>, string?) Constructor with filterJson (legacy compatibility).
I IFacetFilterBuilder redb.Core.Query.FacetFilters
M BuildQueryParameters(int?, int?) Build query parameters (limit, offset).
I IGroupedWindowedQueryable<TKey, TProps> redb.Core.Query.Grouping
I IOrderedRedbQueryable<TProps> redb.Core.Query
I IQueryableProvider redb.Core.Providers
M Query<TProps>() Create type-safe query by type (synchronous).
M Query<TProps>(IRedbUser) Create type-safe query by type with specified user (synchronous).
M TreeQuery<TProps>() Create type-safe tree query by type (synchronous).
M TreeQuery<TProps>(IEnumerable<IRedbObject>, int?) Create tree query limited to subtrees of object list (synchronous).
M TreeQuery<TProps>(IEnumerable<IRedbObject>, IRedbUser, int?) Create tree query limited to subtrees of object list with specified user (synchronous).
M TreeQuery<TProps>(IEnumerable<long>, int?) Create tree query limited to subtrees by ID list (synchronous).
M TreeQuery<TProps>(IEnumerable<long>, IRedbUser, int?) Create tree query limited to subtrees by ID list with specified user (synchronous).
M TreeQuery<TProps>(IRedbObject?, int?) Create tree query limited to subtree (synchronous).
M TreeQuery<TProps>(IRedbObject?, IRedbUser, int?) Create tree query limited to subtree with specified user (synchronous).
M TreeQuery<TProps>(IRedbUser) Create type-safe tree query by type with specified user (synchronous).
M TreeQuery<TProps>(long, int?) Create tree query limited to subtree (synchronous, by ID).
M TreeQuery<TProps>(long, IRedbUser, int?) Create tree query limited to subtree with specified user (synchronous, by ID).
I IRedbConnection redb.Core.Data
M QueryAsync<T>(string, params object[]) Execute SQL query and return list of mapped objects.
M QueryFirstOrDefaultAsync<T>(string, params object[]) Execute SQL query and return first result or null.
M QueryScalarListAsync<T>(string, params object[]) Execute SQL query and return list of scalar values (first column only).
I IRedbContext redb.Core.Data
M QueryAsync<T>(string, params object[]) Execute SQL query and return list of mapped objects.
M QueryFirstOrDefaultAsync<T>(string, params object[]) Execute SQL query and return first result or null.
M QueryScalarListAsync<T>(string, params object[]) Execute SQL query and return list of scalar values (first column only).
I IRedbGroupedQueryable<TKey, TProps> redb.Core.Query.Grouping
I IRedbProjectedQueryable<TResult> redb.Core.Query
I IRedbQueryable<TProps> redb.Core.Query
I IRedbQueryProvider redb.Core.Query
M CreateQuery<TProps>(long, long?, bool) Create new query for specified scheme.
M ExecuteGroupedWindowQueryAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, FilterExpression?) Execute GroupBy with Window Functions with FilterExpression (Pro version).
M ExecuteGroupedWindowQueryAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Execute GroupBy with Window Functions (ranking, running totals on aggregated data).
M ExecuteWindowQueryAsync(long, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, FilterExpression?, string?, int?, int?) Execute query with window functions with FilterExpression (Pro version).
M ExecuteWindowQueryAsync(long, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?, string?, int?, int?) Execute query with window functions (SQL function query_with_window).
M GetFilterJsonAsync<TProps>(QueryContext<TProps>) Returns the JSON filter that will be sent to SQL function (for diagnostics)
M GetSqlPreviewAsync<TProps>(QueryContext<TProps>) Get SQL query for debugging (analogous to ToQueryString in EF Core).
I IRedbWindowedQueryable<TProps> redb.Core.Query.Window
I ISqlDialect redb.Core.Query
M Query_AggregateArrayGroupedSql() SQL for array grouped aggregation.
M Query_AggregateBatchPreviewSql() SQL for aggregate batch preview.
M Query_AggregateBatchSql() SQL for aggregate batch function.
M Query_AggregateFieldSql() SQL for aggregate field.
M Query_AggregateGroupedSql() SQL for grouped aggregation.
M Query_BigintArrayCast() Bigint array cast. PostgreSQL: "::bigint[]"
M Query_CheckPermissionSql() SQL for checking user permission on object.
M Query_CountTemplate() SQL template for COUNT query. Params: functionName
M Query_GetIdsWithAncestorsSql(string) SQL for getting all IDs with their ancestors using recursive CTE.
M Query_GetParentIdsFromDescendantsSql(string, int) SQL for getting parent IDs from descendant IDs using recursive CTE.
M Query_HasAncestorNormalSql(string) SQL for HasAncestor normal search - extracts IDs from JSON result.
M Query_HasAncestorTreeSql(string) SQL for HasAncestor tree search - extracts IDs from JSON result.
M Query_HasDescendantSql(string) SQL for HasDescendant search - extracts IDs from JSON result.
M Query_JsonCast() JSON cast expression for the database.
M Query_LoadObjectsByIdsSql(string, int) SQL for loading objects by IDs as JSON.
M Query_ProjectionByIdsTemplate(string) SQL for projection by structure IDs query.
M Query_ProjectionByPathsTemplate() SQL for projection by paths query.
M Query_SearchFullTemplate() SQL template for full search query with distinct and facets. Params: functionName
M Query_SearchObjectsBaseFunction() Name of the search function for objects base fields only (lazy loading).
M Query_SearchObjectsFunction() Name of the search function for objects with facets (eager loading).
M Query_SearchObjectsProjectionByIdsFunction() Name of the search function with projection by IDs.
M Query_SearchObjectsProjectionByPathsFunction() Name of the search function with projection by paths.
M Query_SearchObjectsSimpleSql() SQL for simple search objects (used in distinct).
M Query_SearchTemplate() SQL template for search query result. Params: functionName
M Query_SearchTreeObjectsBaseFunction() Name of the tree search function base fields only (lazy loading).
M Query_SearchTreeObjectsFunction() Name of the tree search function (eager loading).
M Query_SearchWithDistinctTemplate() SQL template for search query with distinct. Params: functionName
M Query_SqlPreviewBaseFunction() SQL preview function name for base (lazy loading) search.
M Query_SqlPreviewFunction() SQL preview function name for regular search.
M Query_SqlPreviewTemplate() SQL for SQL preview function.
M Query_TextArrayCast() Text array cast. PostgreSQL: "::text[]"
M Query_TreeCountNormalSql(string) SQL for tree count query (normal search).
M Query_TreeCountWithParentIdsSql(string) SQL for tree COUNT with parent_ids array.
M Query_TreeSearchNormalSql(string) SQL for tree search query (normal search).
M Query_TreeSearchWithParentIdsSql(string) SQL for tree search with multiple parent IDs.
M Query_TreeSqlPreviewBaseFunction() SQL preview function name for tree base (lazy loading) search.
M Query_TreeSqlPreviewFunction() SQL preview function name for tree search.
M Query_TreeSqlPreviewTemplate(string) SQL for tree SQL preview.
M Query_WindowSql() SQL for window query.
M WrapSubquery(string, string) Subquery wrapper: (subquery) AS alias
I ITreeQueryProvider redb.Core.Query
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Create tree query with hierarchical constraint support.
M ExecuteTreeGroupedAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Execute GROUP BY aggregation with tree context (CTE for tree traversal).
M ExecuteTreeGroupedWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Execute GroupBy + Window Functions with tree context.
M ExecuteTreeWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Execute Window Functions query with tree context (CTE for tree traversal).
M GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Get SQL preview for tree GROUP BY query (for debugging).
M GetTreeGroupedWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Get SQL preview for tree GroupBy + Window query.
M GetTreeWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Get SQL preview for tree window query (for debugging).
C MsSqlDialect redb.MSSql.Sql
M Query_AggregateArrayGroupedSql() SQL for array grouped aggregation.
M Query_AggregateBatchPreviewSql() SQL for aggregate batch preview.
M Query_AggregateBatchSql() SQL for aggregate batch function.
M Query_AggregateFieldSql() SQL for aggregate field.
M Query_AggregateGroupedSql() SQL for grouped aggregation.
M Query_BigintArrayCast() Bigint array cast. PostgreSQL: "::bigint[]"
M Query_CheckPermissionSql() SQL for checking user permission on object.
M Query_CountTemplate() MSSQL uses EXEC and OPENJSON for JSON parameters.
M Query_GetIdsWithAncestorsSql(string) MSSQL: Get all IDs with their ancestors using recursive CTE.
M Query_GetParentIdsFromDescendantsSql(string, int) MSSQL: WITH (without RECURSIVE) for traversing ancestors.
M Query_HasAncestorNormalSql(string) HasAncestor with normal function (6 params) - MSSQL captures EXEC result in temp table.
M Query_HasAncestorTreeSql(string) HasAncestor with tree function (8 params) - MSSQL captures EXEC result in temp table.
M Query_HasDescendantSql(string) HasDescendant with normal function (6 params) - MSSQL captures EXEC result in temp table.
M Query_JsonCast() MSSQL doesn't need explicit JSON cast - it's handled by function signature.
M Query_LoadObjectsByIdsSql(string, int) MSSQL: Load objects by IDs as JSON using get_object_json function.
M Query_ProjectionByIdsTemplate(string) SQL for projection by structure IDs query.
M Query_ProjectionByPathsTemplate() SQL for projection by paths query.
M Query_SearchFullTemplate() MSSQL always uses _base version, but C# passes 8 params when useLazyLoading=false.
M Query_SearchObjectsBaseFunction() Name of the search function for objects base fields only (lazy loading).
M Query_SearchObjectsFunction() Name of the search function for objects with facets (eager loading).
M Query_SearchObjectsProjectionByIdsFunction() Name of the search function with projection by IDs.
M Query_SearchObjectsProjectionByPathsFunction() Name of the search function with projection by paths.
M Query_SearchObjectsSimpleSql() Simple search for Delete operations - uses search_objects_with_facets with minimal params.
M Query_SearchTemplate() MSSQL uses EXEC for stored procedures. Procedure returns 'result' column.
M Query_SearchTreeObjectsBaseFunction() Name of the tree search function base fields only (lazy loading).
M Query_SearchTreeObjectsFunction() Name of the tree search function (eager loading).
M Query_SearchWithDistinctTemplate() SQL template for search query with distinct. Params: functionName
M Query_SqlPreviewBaseFunction() SQL preview function name for base (lazy loading) search.
M Query_SqlPreviewFunction() SQL preview function name for regular search.
M Query_SqlPreviewTemplate() SQL for SQL preview function.
M Query_TextArrayCast() MSSQL uses STRING_SPLIT instead of array cast.
M Query_TreeCountNormalSql(string) For Tree procedures, we use temp table to capture EXEC result and extract total_count.
M Query_TreeCountWithParentIdsSql(string) MSSQL: capture EXEC result and extract total_count.
M Query_TreeSearchNormalSql(string) SQL for tree search query (normal search).
M Query_TreeSearchWithParentIdsSql(string) Tree search with parent_ids array (8 params).
M Query_TreeSqlPreviewBaseFunction() SQL preview function name for tree base (lazy loading) search.
M Query_TreeSqlPreviewFunction() SQL preview function name for tree search.
M Query_TreeSqlPreviewTemplate(string) SQL for tree SQL preview.
M Query_WindowSql() SQL for window query.
M WrapSubquery(string, string) Subquery wrapper: (subquery) AS alias
C MssqlQueryableProvider redb.MSSql.Providers
M CreateEmptyTreeQuery<TProps>(long, long?, bool) Create empty tree query (for null rootObject case).
M CreateMultiRootTreeQuery<TProps>(long, long?, bool, List<IRedbObject>, int?) Create tree query for multiple root objects.
M CreateMultiRootTreeQueryByIds<TProps>(long, long?, bool, IEnumerable<long>, int?) Create tree query for multiple root object IDs.
M CreateQuery<TProps>(long, long?, bool) Create DB-specific query provider for flat queries.
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Create DB-specific query provider for tree queries.
T MssqlQueryableProvider(IRedbContext, IRedbObjectSerializer, ISchemeSyncProvider, IRedbSecurityContext, ILazyPropsLoader?, RedbServiceConfiguration?, string?, ILogger?)
C MssqlQueryProvider redb.MSSql.Query
T MssqlQueryProvider(IRedbContext, IRedbObjectSerializer, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISchemeSyncProvider?, ISqlDialect?)
C MssqlTreeQueryable<TProps> redb.MSSql.Query
M CreateInstance(TreeQueryContext<TProps>) Creates a new instance with the specified context.
T MssqlTreeQueryable(ITreeQueryProvider, TreeQueryContext<TProps>, IFilterExpressionParser, IOrderingExpressionParser)
C MssqlTreeQueryProvider redb.MSSql.Query
M CreateQueryProvider() Creates query provider for delegation.
M CreateTreeQueryable<TProps>(TreeQueryContext<TProps>) Creates tree queryable instance.
T MssqlTreeQueryProvider(IRedbContext, IRedbObjectSerializer, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISqlDialect?, string?, ISchemeSyncProvider?)
C NpgsqlRedbConnection redb.Postgres.Data
M QueryAsync<T>(string, params object[]) Execute SQL query and map results to list of objects.
M QueryFirstOrDefaultAsync<T>(string, params object[]) Execute SQL query and return first result.
M QueryScalarListAsync<T>(string, params object[]) Execute SQL query and return list of scalar values (first column only).
C PostgreSqlDialect redb.Postgres.Sql
M Query_AggregateArrayGroupedSql() SQL for array grouped aggregation.
M Query_AggregateBatchPreviewSql() SQL for aggregate batch preview.
M Query_AggregateBatchSql() SQL for aggregate batch function.
M Query_AggregateFieldSql() SQL for aggregate field.
M Query_AggregateGroupedSql() SQL for grouped aggregation.
M Query_BigintArrayCast() Bigint array cast. PostgreSQL: "::bigint[]"
M Query_CheckPermissionSql() SQL for checking user permission on object.
M Query_CountTemplate() SQL template for COUNT query. Params: functionName
M Query_GetIdsWithAncestorsSql(string) PostgreSQL: Get all IDs with their ancestors using recursive CTE.
M Query_GetParentIdsFromDescendantsSql(string, int) PostgreSQL: WITH RECURSIVE for traversing ancestors.
M Query_HasAncestorNormalSql(string) HasAncestor with normal function (6 params).
M Query_HasAncestorTreeSql(string) HasAncestor with tree function (8 params).
M Query_HasDescendantSql(string) HasDescendant with normal function (6 params).
M Query_JsonCast() JSON cast expression for the database.
M Query_LoadObjectsByIdsSql(string, int) PostgreSQL: Load objects by IDs as JSON using get_object_json function.
M Query_ProjectionByIdsTemplate(string) SQL for projection by structure IDs query.
M Query_ProjectionByPathsTemplate() SQL for projection by paths query.
M Query_SearchFullTemplate() SQL template for full search query with distinct and facets. Params: functionName
M Query_SearchObjectsBaseFunction() Name of the search function for objects base fields only (lazy loading).
M Query_SearchObjectsFunction() Name of the search function for objects with facets (eager loading).
M Query_SearchObjectsProjectionByIdsFunction() Name of the search function with projection by IDs.
M Query_SearchObjectsProjectionByPathsFunction() Name of the search function with projection by paths.
M Query_SearchObjectsSimpleSql() Simple search for Delete operations - uses search_objects_with_facets with minimal params.
M Query_SearchTemplate() SQL template for search query result. Params: functionName
M Query_SearchTreeObjectsBaseFunction() Name of the tree search function base fields only (lazy loading).
M Query_SearchTreeObjectsFunction() Name of the tree search function (eager loading).
M Query_SearchWithDistinctTemplate() SQL template for search query with distinct. Params: functionName
M Query_SqlPreviewBaseFunction() SQL preview function name for base (lazy loading) search.
M Query_SqlPreviewFunction() SQL preview function name for regular search.
M Query_SqlPreviewTemplate() SQL for SQL preview function.
M Query_TextArrayCast() Text array cast. PostgreSQL: "::text[]"
M Query_TreeCountNormalSql(string) SQL for tree count query (normal search).
M Query_TreeCountWithParentIdsSql(string) PostgreSQL: extract total_count from tree function result.
M Query_TreeSearchNormalSql(string) SQL for tree search query (normal search).
M Query_TreeSearchWithParentIdsSql(string) Tree search with parent_ids array (8 params).
M Query_TreeSqlPreviewBaseFunction() SQL preview function name for tree base (lazy loading) search.
M Query_TreeSqlPreviewFunction() SQL preview function name for tree search.
M Query_TreeSqlPreviewTemplate(string) SQL for tree SQL preview.
M Query_WindowSql() SQL for window query.
M WrapSubquery(string, string) Subquery wrapper: (subquery) AS alias
C PostgresQueryableProvider redb.Postgres.Providers
M CreateEmptyTreeQuery<TProps>(long, long?, bool) Create empty tree query (for null rootObject case).
M CreateMultiRootTreeQuery<TProps>(long, long?, bool, List<IRedbObject>, int?) Create tree query for multiple root objects.
M CreateMultiRootTreeQueryByIds<TProps>(long, long?, bool, IEnumerable<long>, int?) Create tree query for multiple root object IDs.
M CreateQuery<TProps>(long, long?, bool) Create DB-specific query provider for flat queries.
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Create DB-specific query provider for tree queries.
T PostgresQueryableProvider(IRedbContext, IRedbObjectSerializer, ISchemeSyncProvider, IRedbSecurityContext, ILazyPropsLoader?, RedbServiceConfiguration?, string?, ILogger?)
C PostgresQueryProvider redb.Postgres.Query
T PostgresQueryProvider(IRedbContext, IRedbObjectSerializer, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISchemeSyncProvider?, ISqlDialect?)
C PostgresTreeQueryable<TProps> redb.Postgres.Query
M CreateInstance(TreeQueryContext<TProps>) Creates a new instance with the specified context.
T PostgresTreeQueryable(ITreeQueryProvider, TreeQueryContext<TProps>, IFilterExpressionParser, IOrderingExpressionParser)
C PostgresTreeQueryProvider redb.Postgres.Query
M CreateQueryProvider() Creates query provider for delegation.
M CreateTreeQueryable<TProps>(TreeQueryContext<TProps>) Creates tree queryable instance.
T PostgresTreeQueryProvider(IRedbContext, IRedbObjectSerializer, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISqlDialect?, string?, ISchemeSyncProvider?)
E ProFeatureCategory redb.Core.Exceptions
T DistinctQuery DistinctRedb/DistinctBy queries.
C ProQueryableProvider redb.MSSql.Pro.Providers
M CreateMultiRootTreeQuery<TProps>(long, long?, bool, List<IRedbObject>, int?) Override: MultiRoot TreeQuery also uses ProTreeQueryProvider.
M CreateMultiRootTreeQueryByIds<TProps>(long, long?, bool, IEnumerable<long>, int?) Override: MultiRoot TreeQuery by IDs also uses ProTreeQueryProvider.
M CreateQuery<TProps>(long, long?, bool) ⚡ Override: Uses ProQueryProvider instead of MSSqlQueryProvider
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Override: Uses ProTreeQueryProvider instead of MSSqlTreeQueryProvider.
T ProQueryableProvider(IRedbContext, IRedbObjectSerializer, ISchemeSyncProvider, IRedbSecurityContext, ILazyPropsLoader?, RedbServiceConfiguration?, string?, ILogger?, ISqlDialect?)
C ProQueryableProvider redb.Postgres.Pro.Providers
M CreateMultiRootTreeQuery<TProps>(long, long?, bool, List<IRedbObject>, int?) Override: MultiRoot TreeQuery also uses ProTreeQueryProvider.
M CreateMultiRootTreeQueryByIds<TProps>(long, long?, bool, IEnumerable<long>, int?) Override: MultiRoot TreeQuery by IDs also uses ProTreeQueryProvider.
M CreateQuery<TProps>(long, long?, bool) ⚡ Override: Uses ProQueryProvider instead of PostgresQueryProvider
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Override: Uses ProTreeQueryProvider instead of PostgresTreeQueryProvider.
T ProQueryableProvider(IRedbContext, IRedbObjectSerializer, ISchemeSyncProvider, IRedbSecurityContext, ILazyPropsLoader?, RedbServiceConfiguration?, string?, ILogger?, ISqlDialect?)
C ProQueryProvider redb.MSSql.Pro.Query
M CheckProOnlyDistinctFeatures<TProps>(QueryContext<TProps>) Pro version supports all Distinct features
M ExecuteCountAsync<TProps>(QueryContext<TProps>) Pro Override: COUNT via CTE + JOIN (uses BuildQuerySqlAsync).
M ExecuteGroupedWindowQueryAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, FilterExpression?) Execute GroupBy with Window Functions with FilterExpression (Pro version).
M ExecuteGroupedWindowQueryAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Execute GroupBy with Window Functions.
M ExecuteToListAsync<TProps>(QueryContext<TProps>, Type) PVT-based search (uses BuildQuerySqlAsync)
M ExecuteWindowQueryAsync(long, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, FilterExpression?, string?, int?, int?) ⚡ Pro: Window Functions with FilterExpression (preferred).
M ExecuteWindowQueryAsync(long, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?, string?, int?, int?) ⚡ Pro: Window Functions with filterJson (legacy).
M GetAggregateSqlPreviewAsync<TProps, TResult>(QueryContext<TProps>, Expression<Func<RedbObject<TProps>, TResult>>) Pro Override: SQL Preview for aggregation
M GetSqlPreviewAsync<TProps>(QueryContext<TProps>) SQL Preview (uses BuildQuerySqlAsync).
T ProQueryProvider(IRedbContext, IRedbObjectSerializer, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISchemeSyncProvider?, ISqlDialect?)
C ProQueryProvider redb.Postgres.Pro.Query
M CheckProOnlyDistinctFeatures<TProps>(QueryContext<TProps>) Pro version supports all Distinct features.
M ExecuteCountAsync<TProps>(QueryContext<TProps>) Pro Override: COUNT via CTE + JOIN (uses BuildQuerySqlAsync).
M ExecuteGroupedWindowQueryAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, FilterExpression?) Execute GroupBy + Window query with FilterExpression (preferred).
M ExecuteGroupedWindowQueryAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Execute GroupBy + Window query with filterJson (legacy).
M ExecuteToListAsync<TProps>(QueryContext<TProps>, Type) PVT-based search (uses BuildQuerySqlAsync)
M ExecuteWindowQueryAsync(long, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, FilterExpression?, string?, int?, int?) ⚡ Pro: Window Functions with FilterExpression (preferred).
M ExecuteWindowQueryAsync(long, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?, string?, int?, int?) ⚡ Pro: Window Functions with filterJson (legacy).
M GetAggregateSqlPreviewAsync<TProps, TResult>(QueryContext<TProps>, Expression<Func<RedbObject<TProps>, TResult>>) Pro Override: SQL Preview for aggregation
M GetSqlPreviewAsync<TProps>(QueryContext<TProps>) SQL Preview (uses BuildQuerySqlAsync).
T ProQueryProvider(IRedbContext, IRedbObjectSerializer, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISchemeSyncProvider?, ISqlDialect?)
C ProSqlBuilder redb.MSSql.Pro.Query
M BuildLimitOffset<TProps>(QueryContext<TProps>, SqlParameterCollector?) Generates OFFSET/FETCH clause (T-SQL syntax).
M BuildOrderByClause<TProps>(QueryContext<TProps>, IReadOnlyDictionary<string, FieldInfo>, string?, SqlParameterCollector?, IReadOnlySet<string>?, string) Generates ORDER BY clause.
M BuildPropsValueSubquery(FieldInfo, string, int?) Generates subquery for getting Props value.
M BuildPvtSubquery(long, IReadOnlyCollection<FieldInfo>, IReadOnlyCollection<string>, SqlParameterCollector, string?) Generates PVT subquery for GROUP BY (T-SQL syntax).
M BuildSelectClause<TProps>(QueryContext<TProps>, IReadOnlyDictionary<string, FieldInfo>, SqlParameterCollector, IReadOnlySet<string>?, string) Generates SELECT clause with DISTINCT support.
C ProSqlBuilder redb.Postgres.Pro.Query
M BuildLimitOffset<TProps>(QueryContext<TProps>, SqlParameterCollector?) Generates LIMIT/OFFSET clause
M BuildOrderByClause<TProps>(QueryContext<TProps>, IReadOnlyDictionary<string, FieldInfo>, string?, SqlParameterCollector?, IReadOnlySet<string>?, string) Generates ORDER BY clause with DISTINCT ON support.
M BuildPropsValueSubquery(FieldInfo, string, int?) Generates subquery for getting Props value
M BuildPvtSubquery(long, IReadOnlyCollection<FieldInfo>, IReadOnlyCollection<string>, SqlParameterCollector, string?) Generates PVT subquery for GROUP BY
M BuildSelectClause<TProps>(QueryContext<TProps>, IReadOnlyDictionary<string, FieldInfo>, SqlParameterCollector, IReadOnlySet<string>?, string) Generates SELECT clause with DISTINCT ON support.
C ProTreeQueryProvider redb.MSSql.Pro.Query
M ExecuteTreeAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<AggregateRequest>) Execute tree aggregation with CTE.
M ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>) ⚡ Pro Override: Tree Count via CTE + pvt.
M ExecuteTreeGroupByAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Execute GROUP BY on tree with CTE.
M ExecuteTreeGroupedAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) ITreeQueryProvider implementation: Execute GROUP BY with tree context.
M ExecuteTreeGroupedWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Execute GroupBy + Window with tree context.
M ExecuteTreeToListAsync<TProps>(TreeQueryContext<TProps>) ⚡ Pro Override: Tree ToList via CTE + pvt.
M ExecuteTreeWindowAsync<TProps>(TreeQueryContext<TProps>, string, string, string, string, string?) Execute Window Functions on tree with CTE (legacy JSON version).
M ExecuteTreeWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Execute Window Functions on tree with CTE (interface implementation).
M ExecuteWindowQueryAsync(long, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?, string?, int?, int?) Execute query with window functions (SQL function query_with_window).
M GetSqlPreviewAsync<TProps>(TreeQueryContext<TProps>) Pro: Tree SQL Preview (DRY - uses BuildTreeQuerySqlAsync)
M GetTreeAggregateSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<AggregateRequest>) SQL Preview for Tree Aggregate (DRY - same SQL as Execute)
M GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) SQL Preview for Tree GroupBy (DRY - same SQL as Execute)
M GetTreeGroupedWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Get SQL preview for tree GroupBy + Window.
M GetTreeWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) SQL Preview for Tree Window (typed interface version).
M GetTreeWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, string, string, string, string, string?) SQL Preview for Tree Window (DRY - same SQL as Execute)
T ProTreeQueryProvider(IRedbContext, IRedbObjectSerializer, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISqlDialect?, string?, ISchemeSyncProvider?)
C ProTreeQueryProvider redb.Postgres.Pro.Query
M ExecuteTreeAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<AggregateRequest>) Execute tree aggregation with CTE.
M ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>) ⚡ Pro Override: Tree Count via CTE + PVT.
M ExecuteTreeGroupByAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Execute GROUP BY on tree with CTE.
M ExecuteTreeGroupedAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) ITreeQueryProvider implementation: Execute GROUP BY with tree context.
M ExecuteTreeGroupedWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Execute Tree GroupBy + Window query.
M ExecuteTreeToListAsync<TProps>(TreeQueryContext<TProps>) ⚡ Pro Override: Tree ToList via CTE + PVT.
M ExecuteTreeWindowAsync<TProps>(TreeQueryContext<TProps>, string, string, string, string, string?) Execute Window Functions on tree with CTE (legacy JSON version).
M ExecuteTreeWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Execute Window Functions on tree with CTE (interface implementation).
M ExecuteWindowQueryAsync(long, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?, string?, int?, int?) Execute query with window functions (SQL function query_with_window).
M GetSqlPreviewAsync<TProps>(TreeQueryContext<TProps>) Pro: Tree SQL Preview (DRY - uses BuildTreeQuerySqlAsync)
M GetTreeAggregateSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<AggregateRequest>) SQL Preview for Tree Aggregate (DRY - same SQL as Execute)
M GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) SQL Preview for Tree GroupBy (DRY - same SQL as Execute)
M GetTreeGroupedWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) SQL preview for Tree GroupBy + Window.
M GetTreeWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) SQL Preview for Tree Window (typed interface version).
M GetTreeWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, string, string, string, string, string?) SQL Preview for Tree Window (DRY - same SQL as Execute)
T ProTreeQueryProvider(IRedbContext, IRedbObjectSerializer, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISqlDialect?, string?, ISchemeSyncProvider?)
C QueryableProviderBase redb.Core.Providers.Base
M CreateEmptyTreeQuery<TProps>(long, long?, bool) Create empty tree query (for null rootObject case).
M CreateMultiRootTreeQuery<TProps>(long, long?, bool, List<IRedbObject>, int?) Create tree query for multiple root objects.
M CreateMultiRootTreeQueryByIds<TProps>(long, long?, bool, IEnumerable<long>, int?) Create tree query for multiple root object IDs.
M CreateQuery<TProps>(long, long?, bool) Create DB-specific query provider for flat queries.
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Create DB-specific query provider for tree queries.
M Query<TProps>() Create type-safe query by type (synchronous).
M Query<TProps>(IRedbUser) Create type-safe query by type with specified user (synchronous).
T QueryableProviderBase(IRedbContext, IRedbObjectSerializer, ISchemeSyncProvider, IRedbSecurityContext, ILazyPropsLoader?, RedbServiceConfiguration?, string?, ILogger?)
M TreeQuery<TProps>() Create type-safe tree query by type (synchronous).
M TreeQuery<TProps>(IEnumerable<IRedbObject>, int?) Create tree query limited to subtrees of object list (synchronous).
M TreeQuery<TProps>(IEnumerable<IRedbObject>, IRedbUser, int?) Create tree query limited to subtrees of object list with specified user (synchronous).
M TreeQuery<TProps>(IEnumerable<long>, int?) Create tree query limited to subtrees by ID list (synchronous).
M TreeQuery<TProps>(IEnumerable<long>, IRedbUser, int?) Create tree query limited to subtrees by ID list with specified user (synchronous).
M TreeQuery<TProps>(IRedbObject?, int?) Create tree query limited to subtree (synchronous).
M TreeQuery<TProps>(IRedbObject?, IRedbUser, int?) Create tree query limited to subtree with specified user (synchronous).
M TreeQuery<TProps>(IRedbUser) Create type-safe tree query by type with specified user (synchronous).
M TreeQuery<TProps>(long, int?) Create tree query limited to subtree (synchronous, by ID).
M TreeQuery<TProps>(long, IRedbUser, int?) Create tree query limited to subtree with specified user (synchronous, by ID).
C QueryContext<TProps> redb.Core.Query
T QueryContext(long, long?, bool, long?, int?)
C QueryParameters redb.Core.Query.FacetFilters
T QueryParameters(int?, int?) Query parameters.
C QueryProviderBase redb.Core.Query.Base
M CheckProOnlyDistinctFeatures<TProps>(QueryContext<TProps>) Check for Pro-only Distinct features
M CreateQuery<TProps>(long, long?, bool) Create new query for specified scheme.
M ExecuteCountAsync<TProps>(QueryContext<TProps>) Executes COUNT query. Override in Pro for PVT-based count with computed expressions.
M ExecuteGroupedWindowQueryAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, FilterExpression?) Execute GroupBy with Window Functions with FilterExpression (Pro version).
M ExecuteGroupedWindowQueryAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Execute GroupBy with Window Functions.
M ExecuteToListAsync<TProps>(QueryContext<TProps>, Type)
M ExecuteWindowQueryAsync(long, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, FilterExpression?, string?, int?, int?) Execute window query with FilterExpression (Pro version).
M ExecuteWindowQueryAsync(long, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?, string?, int?, int?) Execute query with window functions (SQL function query_with_window).
M GetAggregateSqlPreviewAsync<TProps, TResult>(QueryContext<TProps>, Expression<Func<RedbObject<TProps>, TResult>>) 🔍 Returns SQL query for aggregation (for debugging)
M GetFilterJsonAsync<TProps>(QueryContext<TProps>) Returns the JSON filter that will be sent to SQL function (for diagnostics)
M GetSqlPreviewAsync<TProps>(QueryContext<TProps>) Returns the SQL query that will be executed (for debugging)
T QueryProviderBase(IRedbContext, IRedbObjectSerializer, ISqlDialect, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISchemeSyncProvider?)
M ShouldUseLazyLoading<TProps>(QueryContext<TProps>) Determines if lazy loading should be used for this query
C RedbArrayGroupedQueryable<TKey, TItem, TProps> redb.Core.Query.Grouping
T RedbArrayGroupedQueryable(IRedbQueryProvider, long, string?, Expression<Func<TProps, IEnumerable<TItem>>>, Expression<Func<TItem, TKey>>)
C RedbContextBase redb.Core.Data
M QueryAsync<T>(string, params object[]) Execute SQL query and return list of mapped objects.
M QueryFirstOrDefaultAsync<T>(string, params object[]) Execute SQL query and return first result or null.
M QueryScalarListAsync<T>(string, params object[]) Execute SQL query and return list of scalar values (first column only).
C RedbGroupedQueryable<TKey, TProps> redb.Core.Query.Grouping
T RedbGroupedQueryable(IRedbQueryProvider, long, FilterExpression?, Expression, bool) Constructor with FilterExpression (Pro version - direct access to filter).
T RedbGroupedQueryable(IRedbQueryProvider, long, string?, Expression, bool) Constructor with filterJson (Free version compatibility).
C RedbProjectedQueryable<TProps, TResult> redb.Core.Query
T RedbProjectedQueryable(IRedbQueryable<TProps>, Expression<Func<RedbObject<TProps>, TResult>>, IRedbQueryProvider, long) ⭐ Constructor with provider for optimized loading
T RedbProjectedQueryable(IRedbQueryable<TProps>, Expression<Func<RedbObject<TProps>, TResult>>)
C RedbProjectedQueryableTaskExtensions redb.Core.Query
M CountAsync<TResult>(Task<IRedbProjectedQueryable<TResult>>)
M Distinct<TResult>(Task<IRedbProjectedQueryable<TResult>>)
M FirstOrDefaultAsync<TResult>(Task<IRedbProjectedQueryable<TResult>>)
M OrderBy<TResult, TKey>(Task<IRedbProjectedQueryable<TResult>>, Expression<Func<TResult, TKey>>)
M OrderByDescending<TResult, TKey>(Task<IRedbProjectedQueryable<TResult>>, Expression<Func<TResult, TKey>>)
M Skip<TResult>(Task<IRedbProjectedQueryable<TResult>>, int)
M Take<TResult>(Task<IRedbProjectedQueryable<TResult>>, int)
M ToListAsync<TResult>(Task<IRedbProjectedQueryable<TResult>>)
M Where<TResult>(Task<IRedbProjectedQueryable<TResult>>, Expression<Func<TResult, bool>>)
C RedbQueryable<TProps> redb.Core.Query
T RedbQueryable(IRedbQueryProvider, QueryContext<TProps>, IFilterExpressionParser, IOrderingExpressionParser, IFacetFilterBuilder?)
C RedbQueryableExtensions redb.Core.Query
M ToAggregateSqlStringAsync<TProps, TResult>(IRedbQueryable<TProps>, Expression<Func<RedbObject<TProps>, TResult>>) Returns the SQL query for aggregation (for debugging).
M ToSqlStringAsync<TProps>(IRedbQueryable<TProps>) Returns the SQL query that will be executed (for debugging).
C RedbService redb.MSSql
M CreateQueryableProvider(IRedbContext, IRedbObjectSerializer, ISchemeSyncProvider, IRedbSecurityContext, ILazyPropsLoader, RedbServiceConfiguration, string, ILogger?) Create queryable provider.
C RedbService redb.Postgres
M CreateQueryableProvider(IRedbContext, IRedbObjectSerializer, ISchemeSyncProvider, IRedbSecurityContext, ILazyPropsLoader, RedbServiceConfiguration, string, ILogger?) Create queryable provider.
C RedbServiceBase redb.Core
T _queryProvider
M CreateQueryableProvider(IRedbContext, IRedbObjectSerializer, ISchemeSyncProvider, IRedbSecurityContext, ILazyPropsLoader, RedbServiceConfiguration, string, ILogger?) Create queryable provider.
M Query<TProps>() Create type-safe query by type (synchronous).
M Query<TProps>(IRedbUser) Create type-safe query by type with specified user (synchronous).
M TreeQuery<TProps>() Create type-safe tree query by type (synchronous).
M TreeQuery<TProps>(IEnumerable<IRedbObject>, int?) Create tree query limited to subtrees of object list (synchronous).
M TreeQuery<TProps>(IEnumerable<IRedbObject>, IRedbUser, int?) Create tree query limited to subtrees of object list with specified user (synchronous).
M TreeQuery<TProps>(IEnumerable<long>, int?) Create tree query limited to subtrees by ID list (synchronous).
M TreeQuery<TProps>(IEnumerable<long>, IRedbUser, int?) Create tree query limited to subtrees by ID list with specified user (synchronous).
M TreeQuery<TProps>(IRedbObject?, int?) Create tree query limited to subtree (synchronous).
M TreeQuery<TProps>(IRedbObject?, IRedbUser, int?) Create tree query limited to subtree with specified user (synchronous).
M TreeQuery<TProps>(IRedbUser) Create type-safe tree query by type with specified user (synchronous).
M TreeQuery<TProps>(long, int?) Create tree query limited to subtree (synchronous, by ID).
M TreeQuery<TProps>(long, IRedbUser, int?) Create tree query limited to subtree with specified user (synchronous, by ID).
C RedbServiceConfiguration redb.Core.Models.Configuration
P DefaultCheckPermissionsOnQuery Check permissions by default when executing queries.
C RedbWindowedQueryable<TProps> redb.Core.Query.Window
T RedbWindowedQueryable(IRedbQueryProvider, long, FilterExpression?, WindowSpec<TProps>, int?, int?) Constructor with FilterExpression (Pro version).
T RedbWindowedQueryable(IRedbQueryProvider, long, string?, WindowSpec<TProps>, int?, int?) Constructor with filterJson (legacy compatibility).
C SqlRedbConnection redb.MSSql.Data
M QueryAsync<T>(string, params object[]) Execute SQL query and map results to list of objects.
M QueryFirstOrDefaultAsync<T>(string, params object[]) Execute SQL query and return first result.
M QueryScalarListAsync<T>(string, params object[]) Execute SQL query and return list of scalar values (first column only).
C TreeGroupedQueryable<TKey, TProps> redb.Core.Query.Grouping
T TreeGroupedQueryable(ITreeQueryProvider, TreeQueryContext<TProps>, Expression, string?, bool)
C TreeGroupedWindowedQueryable<TKey, TProps> redb.Core.Query.Grouping
T TreeGroupedWindowedQueryable(ITreeQueryProvider, TreeQueryContext<TProps>, Expression, GroupedWindowSpec<TKey, TProps>)
C TreeProjectedQueryable<TProps, TResult> redb.Core.Query
T TreeProjectedQueryable(IRedbQueryable<TProps>, Expression<Func<TreeRedbObject<TProps>, TResult>>)
C TreeQueryableBase<TProps> redb.Core.Query.Base
M CreateInstance(TreeQueryContext<TProps>) Creates a new instance with the specified context. Override in derived classes.
T TreeQueryableBase(ITreeQueryProvider, TreeQueryContext<TProps>, IFilterExpressionParser, IOrderingExpressionParser, IFacetFilterBuilder?)
C TreeQueryContext<TProps> redb.Core.Query.Base
T TreeQueryContext(long, long?, bool, long?, int?)
C TreeQueryProviderBase redb.Core.Query.Base
M CheckProOnlyDistinctFeatures<TProps>(QueryContext<TProps>) Check for Pro-only Distinct features (DistinctBy, DistinctByRedb, DistinctRedb).
M CreateQuery<TProps>(long, long?, bool) Create new query for specified scheme.
M CreateQueryProvider() Creates query provider for delegation. Override in derived classes.
M CreateTreeQuery<TProps>(long, long?, bool, long?, int?) Create tree query with hierarchical constraint support.
M CreateTreeQueryable<TProps>(TreeQueryContext<TProps>) Creates tree queryable instance. Override in derived classes.
M ExecuteGroupedWindowQueryAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, FilterExpression?) Execute GroupBy with Window Functions with FilterExpression (Pro version).
M ExecuteGroupedWindowQueryAsync(long, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Execute GroupBy with Window Functions (ranking, running totals on aggregated data).
M ExecuteOptimizedWhereHasAncestor<TProps>(TreeQueryContext<TProps>, TreeFilter) Optimized execution of WhereHasAncestor through logic inversion:
M ExecuteOptimizedWhereHasDescendant<TProps>(TreeQueryContext<TProps>, TreeFilter) Optimized execution of WhereHasDescendant through logic inversion:
M ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>) Execute COUNT for tree query through search_tree_objects_with_facets
M ExecuteTreeGroupedAggregateAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Execute GROUP BY with tree context (CTE for tree traversal).
M ExecuteTreeGroupedWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Execute GroupBy + Window with tree context.
M ExecuteTreeToListAsync<TProps>(TreeQueryContext<TProps>) Execute ToList for tree query through search_tree_objects_with_facets
M ExecuteTreeWindowQueryAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Execute Window Functions with tree context.
M ExecuteWindowQueryAsync(long, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, FilterExpression?, string?, int?, int?) Execute query with window functions with FilterExpression (Pro version).
M ExecuteWindowQueryAsync(long, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?, string?, int?, int?) Execute query with window functions (SQL function query_with_window).
M GetFilterJsonAsync<TProps>(QueryContext<TProps>) Returns the JSON filter that will be sent to SQL function (for diagnostics)
M GetOptimizableHasAncestorFilter<TProps>(TreeQueryContext<TProps>) Determines if WhereHasAncestor can be optimized through logic inversion
M GetOptimizableHasDescendantFilter<TProps>(TreeQueryContext<TProps>) Determines if WhereHasDescendant can be optimized through logic inversion
M GetSqlPreviewAsync<TProps>(QueryContext<TProps>) Get SQL preview for standard QueryContext (for IRedbQueryProvider compatibility)
M GetSqlPreviewAsync<TProps>(TreeQueryContext<TProps>) Returns SQL query for tree search that will be executed (for debugging)
M GetTreeGroupBySqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>) Get SQL preview for tree GROUP BY query.
M GetTreeGroupedWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<GroupFieldRequest>, IEnumerable<AggregateRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>) Get SQL preview for tree GroupBy + Window.
M GetTreeWindowSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowFuncRequest>, IEnumerable<WindowFieldRequest>, IEnumerable<WindowOrderRequest>, string?) Get SQL preview for tree window query.
M ShouldUseLazyLoading<TProps>(QueryContext<TProps>) Determines if lazy loading should be used for this query.
M ShouldUseLazyLoading<TProps>(TreeQueryContext<TProps>) Determines if lazy loading should be used for tree query.
T TreeQueryProviderBase(IRedbContext, IRedbObjectSerializer, ISqlDialect, string?, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISchemeSyncProvider?)
C TreeQuerySqlResult redb.MSSql.Pro.Query
T TreeQuerySqlResult(string, SqlParameterCollector, string?) Result of SQL generation for Tree Query
C TreeQuerySqlResult redb.Postgres.Pro.Query
T TreeQuerySqlResult(string, SqlParameterCollector, string?) Result of SQL generation for Tree Query
C TreeWindowedQueryable<TProps> redb.Core.Query.Window
T TreeWindowedQueryable(ITreeQueryProvider, TreeQueryContext<TProps>, string?, WindowSpec<TProps>) Creates tree-aware windowed queryable.