Документация RedBase

Добро пожаловать в документацию RedBase. Обзор API, примеры кода и руководства по работе с REDB.

API Reference

Обзор документации REDB API. Выберите пространство имён или тип в дереве слева, или кликните по элементам ниже.

Результаты поиска: Query Очистить
C appExt redb.Core.Utils
M Filter<T>(IQueryable<T>, string, object) Filter IQueryable by property name dynamically.
C ArrayGroupQuery redb.Core.Query.Grouping
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 E096_TreeQuery_ef redb.Examples.ExamplesEf
C E097_TreeQueryRoots redb.Examples.Examples
C E097_TreeQueryRoots_ef redb.Examples.ExamplesEf
C E098_TreeQueryLeaves redb.Examples.Examples
C E098_TreeQueryLeaves_ef redb.Examples.ExamplesEf
C E099_TreeQueryLevel redb.Examples.Examples
C E099_TreeQueryLevel_ef redb.Examples.ExamplesEf
C E105_TreeQueryWithRoot redb.Examples.Examples
C E105_TreeQueryWithRoot_ef redb.Examples.ExamplesEf
C E106_TreeQueryChildrenOf redb.Examples.Examples
C E106_TreeQueryChildrenOf_ef redb.Examples.ExamplesEf
C E107_TreeQueryMultiRoot redb.Examples.Examples
C E107_TreeQueryMultiRoot_ef redb.Examples.ExamplesEf
C E160_TreeQueryExpressions redb.Examples.Examples
C E160_TreeQueryExpressions_ef redb.Examples.ExamplesEf
C E173_TreeQueryGroupBy redb.Examples.Examples
C E173_TreeQueryGroupBy_ef redb.Examples.ExamplesEf
C E174_TreeQueryWindow redb.Examples.Examples
C E174_TreeQueryWindow_ef redb.Examples.ExamplesEf
C E175_TreeQueryGroupByWindow redb.Examples.Examples
C E175_TreeQueryGroupByWindow_ef redb.Examples.ExamplesEf
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 IdSubqueryExpression redb.Core.Pro.Query
T IdSubqueryExpression(string) "The object id is one of those this statement selects": the condition a Pro statement that aggregate...
I IFacetFilterBuilder redb.Core.Query.FacetFilters
M BuildQueryParameters(int?, int?) Build query parameters (limit, offset).
I IGroupedWindowedQueryable<TKey, TProps> redb.Core.Query.Grouping
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 Query<T>(string, params object[]) Synchronous : runs on the calling thread down to ADO.NET.
M QueryAsync<T>(string, object[], CancellationToken) Cancellable form: parameters as an explicit array (params cannot precede ct).
M QueryAsync<T>(string, params object[]) Execute SQL query and return list of mapped objects.
M QueryFirstOrDefault<T>(string, params object[]) Synchronous : runs on the calling thread down to ADO.NET.
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 Query<T>(string, params object[]) Synchronous on the calling thread.
M QueryAsync<T>(string, object[], CancellationToken) Cancellable form: parameters as an explicit array (params cannot precede ct).
M QueryAsync<T>(string, params object[]) Execute SQL query and return list of mapped objects.
M QueryFirstOrDefault<T>(string, params object[]) Synchronous on the calling thread.
M QueryFirstOrDefaultAsync<T>(string, params object[]) Execute SQL query and return first result or null.
M QueryRowsAsJsonAsync(string, object[], CancellationToken) The rows of sql as a JSON array of objects keyed by column name, NULL values included;
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 IRedbQueryable<TProps> redb.Core.Query
I IRedbQueryProvider redb.Core.Query
M CreateQuery<TProps>(long, long?, bool) Create new query for specified scheme.
M ExecuteArrayGroupQueryAsync(ArrayGroupQuery, CancellationToken) Runs a grouping over the elements of an array (GroupByArray, with or without a window over the group...
M GetArrayGroupQuerySqlAsync(ArrayGroupQuery, CancellationToken) The SQL runs for the same request, for ToSqlStringAsync.
M GetFilterJsonAsync<TProps>(QueryContext<TProps>, CancellationToken) Returns the JSON filter that will be sent to SQL function (for diagnostics)
M GetFilterJsonAsync<TProps>(QueryContext<TProps>) Returns the JSON filter that will be sent to SQL function (for diagnostics)
M GetSqlPreviewAsync<TProps>(QueryContext<TProps>, CancellationToken) Get SQL query for debugging (analogous to ToQueryString in EF Core).
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_BuildPvtProjectionSqlFunction() Bare SQL function name returning the projection SELECT string.
M Query_BuildPvtSqlFunction() Bare SQL function name returning the inner _id-list SQL string.
M Query_BuildPvtSqlInvocation(long, int?, int, int, bool, string, long[]?, bool) Builds the full SELECT statement that invokes pvt_build_query_sql.
M Query_CheckPermissionSql() SQL for checking user permission on object.
M Query_CountTemplate() SQL template for COUNT query. Params: functionName
M Query_GetDescendantIdsFromAncestorsSql(string, int) SQL for the ids of the descendants of the given objects, down to depthLimit levels below them
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_PvtModuleCompatFunction() Bare SQL function name returning what a deployed module still serves: '<oldest package module versio...
M Query_PvtModuleVersionFunction() Bare SQL function name returning the deployed v2-pvt module
M Query_PvtRequiredVersion() Semver string the shipped v2-pvt bundle for this dialect declares.
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 Query_WrapPvtProjectionRowsAsJson(string, bool) Wraps the projection inner SQL into a result-set of JSON rows
M Query_WrapPvtWithCount(string) Wraps the inner _id-list SQL with COUNT(*).
M Query_WrapPvtWithExists(string) Wraps the inner _id-list SQL with EXISTS(...).
M Query_WrapPvtWithObjectJson(string, int) Wraps the inner _id-list SQL with the system materializer to
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 ExecuteTreeArrayGroupQueryAsync<TProps>(TreeQueryContext<TProps>, ArrayGroupQuery, CancellationToken) Runs a grouping over the elements of an array for the objects of a subtree: the objects the tree con...
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_BuildPvtProjectionSqlFunction() Bare SQL function name returning the projection SELECT string.
M Query_BuildPvtSqlFunction() Bare SQL function name returning the inner _id-list SQL string.
M Query_BuildPvtSqlInvocation(long, int?, int, int, bool, string, long[]?, bool) Builds the full SELECT statement that invokes pvt_build_query_sql.
M Query_CheckPermissionSql() SQL for checking user permission on object.
M Query_CountTemplate() MSSQL uses EXEC and OPENJSON for JSON parameters.
M Query_GetDescendantIdsFromAncestorsSql(string, int) MSSQL: the descendants of the given objects down to depthLimit levels below them (WITH, without RECU...
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_PvtModuleCompatFunction() Bare SQL function name returning what a deployed module still serves: '<oldest package module versio...
M Query_PvtModuleVersionFunction() Bare SQL function name returning the deployed v2-pvt module
M Query_PvtRequiredVersion() Semver string the shipped v2-pvt bundle for this dialect declares.
M Query_SearchFullTemplate() MSSQL always uses the _base version; the C# side passes 8 params (the include_facets slot stays).
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 - LEGACY. MSSql free must migrate to PVT pipeline.
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 Query_WrapPvtProjectionRowsAsJson(string, bool) Wraps the projection inner SQL into a result-set of JSON rows
M Query_WrapPvtWithCount(string) Wraps the inner _id-list SQL with COUNT(*).
M Query_WrapPvtWithExists(string) Wraps the inner _id-list SQL with EXISTS(...).
M Query_WrapPvtWithObjectJson(string, int) Wraps the inner _id-list SQL with the system materializer to
M WrapSubquery(string, string) Subquery wrapper: (subquery) AS alias
C MssqlQueryProvider redb.MSSql.Query
M ExecuteArrayGroupQueryAsync(ArrayGroupQuery, CancellationToken) GroupByArray on the free SQL Server provider: dbo.pvt_build_array_groupby_sql of the module builds t...
C NpgsqlRedbConnection redb.Postgres.Data
M Query<T>(string, params object[]) Synchronous : runs on the calling thread down to ADO.NET.
M QueryAsync<T>(string, object[], CancellationToken) Cancellable form: parameters as an explicit array (params cannot precede ct).
M QueryAsync<T>(string, params object[]) Execute SQL query and map results to list of objects.
M QueryFirstOrDefault<T>(string, params object[]) Synchronous : runs on the calling thread down to ADO.NET.
M QueryFirstOrDefaultAsync<T>(string, params object[]) Execute SQL query and return first result.
M QueryRowsAsJsonAsync(string, object[], CancellationToken) Execute SQL and serialize the result rows to a JSON array string in C# (column names from the reader...
M QueryScalarListAsync<T>(string, params object[]) Execute SQL query and return list of scalar values (first column only).
C NpgsqlRedbContext redb.Postgres.Data
M QueryRowsAsJsonCoreAsync(string, object[], CancellationToken) The provider's row-to-JSON read behind , run on : every
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_BuildPvtProjectionSqlFunction() Bare SQL function name returning the projection SELECT string.
M Query_BuildPvtSqlFunction() Bare SQL function name returning the inner _id-list SQL string.
M Query_BuildPvtSqlInvocation(long, int?, int, int, bool, string, long[]?, bool) Builds the full SELECT statement that invokes pvt_build_query_sql.
M Query_CheckPermissionSql() SQL for checking user permission on object.
M Query_CountTemplate() SQL template for COUNT query. Params: functionName
M Query_GetDescendantIdsFromAncestorsSql(string, int) PostgreSQL: the descendants of the given objects down to depthLimit levels below them.
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_PvtModuleCompatFunction() Bare SQL function name returning what a deployed module still serves: '<oldest package module versio...
M Query_PvtModuleVersionFunction() Bare SQL function name returning the deployed v2-pvt module
M Query_PvtRequiredVersion() Semver string the shipped v2-pvt bundle for this dialect declares.
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 - LEGACY. PG must migrate to PVT pipeline.
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 Query_WrapPvtProjectionRowsAsJson(string, bool) Wraps the projection inner SQL into a result-set of JSON rows
M Query_WrapPvtWithCount(string) Wraps the inner _id-list SQL with COUNT(*).
M Query_WrapPvtWithExists(string) Wraps the inner _id-list SQL with EXISTS(...).
M Query_WrapPvtWithObjectJson(string, int) Wraps the inner _id-list SQL with the system materializer to
M WrapSubquery(string, string) Subquery wrapper: (subquery) AS alias
C PostgresQueryProvider redb.Postgres.Query
M ExecuteArrayGroupQueryAsync(ArrayGroupQuery, CancellationToken) GroupByArray on the free PostgreSQL provider: pvt_build_array_groupby_sql of the module builds the
C PostgresTreeQueryProvider redb.Postgres.Query
M CreateQueryProvider() Creates query provider for delegation.
M ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>, CancellationToken) Execute COUNT for tree query through search_tree_objects_with_facets
M ExecuteTreeToListAsync<TProps>(TreeQueryContext<TProps>, CancellationToken) Execute ToList for tree query through search_tree_objects_with_facets
M GetSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, CancellationToken) SQL preview of a tree query: the statement pvt_build_query_sql compiles for it, with
M WithIdsInstead<TProps>(TreeQueryContext<TProps>, TreeFilter, IReadOnlyCollection<long>) The query without treeFilter, its object id confined to ids.
E ProFeatureCategory redb.Core.Exceptions
T DistinctQuery DistinctRedb/DistinctBy queries.
C ProQueryableProvider redb.MSSql.Pro.Providers
C ProQueryProvider redb.MSSql.Pro.Query
M CheckProOnlyDistinctFeatures<TProps>(QueryContext<TProps>) Pro version supports all Distinct features
M ExecuteAnyAsync<TProps>(QueryContext<TProps>, CancellationToken) Pro Override: existence without counting. Where the streams form applies, TOP (1) over the
M ExecuteArrayGroupQueryAsync(ArrayGroupQuery, CancellationToken) GroupByArray on the free SQL Server provider: dbo.pvt_build_array_groupby_sql of the module builds t...
M ExecuteCountAsync<TProps>(QueryContext<TProps>, CancellationToken) Pro Override: COUNT via CTE + JOIN (uses BuildQuerySqlAsync).
M ExecuteCountAsync<TProps>(QueryContext<TProps>) Pro Override: COUNT via CTE + JOIN (uses BuildQuerySqlAsync).
M ExecuteToListAsync<TProps>(QueryContext<TProps>, Type) PVT-based search (uses BuildQuerySqlAsync)
M GetSqlPreviewAsync<TProps>(QueryContext<TProps>) SQL Preview (uses BuildQuerySqlAsync).
C ProQueryProvider redb.Postgres.Pro.Query
M CheckProOnlyDistinctFeatures<TProps>(QueryContext<TProps>) Pro version supports all Distinct features.
M ExecuteAnyAsync<TProps>(QueryContext<TProps>, CancellationToken) Is there at least one object the query returns. The default is the count compared with
M ExecuteArrayGroupQueryAsync(ArrayGroupQuery, CancellationToken) GroupByArray on the free PostgreSQL provider: pvt_build_array_groupby_sql of the module builds the
M ExecuteCountAsync<TProps>(QueryContext<TProps>, CancellationToken) Pro Override: COUNT via CTE + JOIN (uses BuildQuerySqlAsync).
M ExecuteCountAsync<TProps>(QueryContext<TProps>) Pro Override: COUNT via CTE + JOIN (uses BuildQuerySqlAsync).
M ExecuteToListAsync<TProps>(QueryContext<TProps>, Type) PVT-based search (uses BuildQuerySqlAsync)
M GetSqlPreviewAsync<TProps>(QueryContext<TProps>) SQL Preview (uses BuildQuerySqlAsync).
C ProTreeQueryProvider redb.MSSql.Pro.Query
M ExecuteArrayGroupQueryAsync(ArrayGroupQuery, CancellationToken) Array grouping without a tree: the flat provider answers it.
M ExecuteTreeAnyAsync<TProps>(TreeQueryContext<TProps>, CancellationToken) Pro Override: Tree Any as the list statement cut to one node (FETCH NEXT 1, no ordering of the query...
M ExecuteTreeArrayGroupQueryAsync<TProps>(TreeQueryContext<TProps>, ArrayGroupQuery, CancellationToken) Array grouping over the objects of a subtree. Base implementation: the ids of the subtree (roots, de...
M ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>) ⚡ Pro Override: Tree Count via CTE + pvt.
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 GetSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, CancellationToken) Pro: Tree SQL Preview (DRY - uses BuildTreeQuerySqlAsync)
M GetSqlPreviewAsync<TProps>(TreeQueryContext<TProps>) Pro: Tree SQL Preview (DRY - uses BuildTreeQuerySqlAsync)
C ProTreeQueryProvider redb.Postgres.Pro.Query
M ExecuteArrayGroupQueryAsync(ArrayGroupQuery, CancellationToken) Array grouping without a tree: the flat provider answers it.
M ExecuteTreeAnyAsync<TProps>(TreeQueryContext<TProps>, CancellationToken) Pro Override: Tree Any as the list statement cut to one node (LIMIT 1, no ordering), the first colum...
M ExecuteTreeArrayGroupQueryAsync<TProps>(TreeQueryContext<TProps>, ArrayGroupQuery, CancellationToken) Array grouping over the objects of a subtree. Base implementation: the ids of the subtree (roots, de...
M ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>) ⚡ Pro Override: Tree Count via CTE + PVT.
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 GetSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, CancellationToken) Pro: Tree SQL Preview (DRY - uses BuildTreeQuerySqlAsync)
M GetSqlPreviewAsync<TProps>(TreeQueryContext<TProps>) Pro: Tree SQL Preview (DRY - uses BuildTreeQuerySqlAsync)
E PvtPrefilterReason redb.Core.Pro.Query
T NotPlainQuery DISTINCT in any form: the streams form does not build the DISTINCT ON select list.
C QueryableProviderBase redb.Core.Providers.Base
M CreateEmptyTreeQuery<TProps>(long, long?, bool) Create empty tree query (for null rootObject case).
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).
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 QueryParameters redb.Core.Query.FacetFilters
T QueryParameters(int?, int?) Query parameters.
C QueryProviderBase redb.Core.Query.Base
M BuildPvtInnerSqlAsync<TProps>(QueryContext<TProps>, bool, CancellationToken) Phase 1: ask the database to build the inner _id-list SQL string.
M CanUsePvtPipeline<TProps>(QueryContext<TProps>) Returns true when the active dialect exposes the v2-pvt module.
M CanUsePvtProjection<TProps>(QueryContext<TProps>) Returns true when the active dialect exposes native PVT projection
M CheckProOnlyDistinctFeatures<TProps>(QueryContext<TProps>) Hook for Distinct-related feature checks. No-op in OSS — DistinctRedb /
M CreateQuery<TProps>(long, long?, bool) Create new query for specified scheme.
M ExecuteAnyAsync<TProps>(QueryContext<TProps>, CancellationToken) Is there at least one object the query returns. The default is the count compared with
M ExecuteArrayGroupQueryAsync(ArrayGroupQuery, CancellationToken) Grouping over the elements of an array. Every provider that supports GroupByArray overrides it; a pr...
M ExecuteCountAsync<TProps>(QueryContext<TProps>, CancellationToken) Executes COUNT query. Override in Pro for PVT-based count with computed expressions.
M ExecuteCountAsync<TProps>(QueryContext<TProps>) Executes COUNT query. Override in Pro for PVT-based count with computed expressions.
M ExecuteCountAsyncPvt<TProps>(QueryContext<TProps>, CancellationToken) v2-pvt Count path: COUNT(*) wrapper over the inner _id-list SQL.
M ExecuteToListAsyncPvt<TProps>(QueryContext<TProps>, Type, CancellationToken) v2-pvt ToList path: wraps the inner SQL with get_object_json, executes,
M ExecuteToListAsyncPvtProjection<TProps>(QueryContext<TProps>, CancellationToken) v2-pvt native projection path. Builds a projection JSON from
M GetFilterJsonAsync<TProps>(QueryContext<TProps>, CancellationToken) Returns the JSON filter that will be sent to SQL function (for diagnostics)
M GetFilterJsonAsync<TProps>(QueryContext<TProps>) Returns the JSON filter that will be sent to SQL function (for diagnostics)
M GetSqlPreviewAsync<TProps>(QueryContext<TProps>, CancellationToken) Returns the SQL query that will be executed (for debugging)
M GetSqlPreviewAsync<TProps>(QueryContext<TProps>) Returns the SQL query that will be executed (for debugging)
M GetSqlPreviewAsyncPvt<TProps>(QueryContext<TProps>, CancellationToken) v2-pvt SQL preview path: returns the inner _id-list SQL as-is.
M ShouldUseLazyLoading<TProps>(QueryContext<TProps>) Determines if lazy loading should be used for this query
C RedbContextBase redb.Core.Data
M QueryAsync<T>(string, object[], CancellationToken) Cancellable form: parameters as an explicit array (params cannot precede ct).
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 QueryRowsAsJsonAsync(string, object[], CancellationToken) The rows of sql as a JSON array of objects keyed by column name, NULL values included;
M QueryRowsAsJsonCoreAsync(string, object[], CancellationToken) The provider's row-to-JSON read behind , run on : every
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 RedbQueryableExtensions redb.Core.Query
M ToSqlStringAsync<TProps>(IRedbQueryable<TProps>) Returns the SQL query that will be executed (for debugging).
C RedbServiceBase redb.Core
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 SqlRedbConnection redb.MSSql.Data
M Query<T>(string, params object[]) Synchronous : runs on the calling thread down to ADO.NET.
M QueryAsync<T>(string, object[], CancellationToken) Cancellable form: parameters as an explicit array (params cannot precede ct).
M QueryAsync<T>(string, params object[]) Execute SQL query and return list of mapped objects.
M QueryFirstOrDefault<T>(string, params object[]) Synchronous : runs on the calling thread down to ADO.NET.
M QueryFirstOrDefaultAsync<T>(string, params object[]) Execute SQL query and return first result.
M QueryRowsAsJsonAsync(string, object[], CancellationToken) Execute SQL and serialize the result rows to a JSON array string in C# (column names from the reader...
M QueryScalarListAsync<T>(string, params object[]) Execute SQL query and return list of scalar values (first column only).
C SqlRedbContext redb.MSSql.Data
M QueryRowsAsJsonCoreAsync(string, object[], CancellationToken) The provider's row-to-JSON read behind , run on : every
C TreeQueryProviderBase redb.Core.Query.Base
M BuildPvtDistinctOnJson<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 ExecuteArrayGroupQueryAsync(ArrayGroupQuery, CancellationToken) Array grouping without a tree: the flat provider answers it.
M ExecuteOptimizedWhereHasAncestor<TProps>(TreeQueryContext<TProps>, TreeFilter, CancellationToken) Optimized execution of WhereHasAncestor through logic inversion:
M ExecuteOptimizedWhereHasAncestor<TProps>(TreeQueryContext<TProps>, TreeFilter) Optimized execution of WhereHasAncestor through logic inversion:
M ExecuteOptimizedWhereHasDescendant<TProps>(TreeQueryContext<TProps>, TreeFilter, CancellationToken) Optimized execution of WhereHasDescendant through logic inversion:
M ExecuteOptimizedWhereHasDescendant<TProps>(TreeQueryContext<TProps>, TreeFilter) Optimized execution of WhereHasDescendant through logic inversion:
M ExecuteTreeAnyAsync<TProps>(TreeQueryContext<TProps>, CancellationToken) Is there at least one node the query returns (no Take or Skip: the queryable answers a page by its c...
M ExecuteTreeArrayGroupQueryAsync<TProps>(TreeQueryContext<TProps>, ArrayGroupQuery, CancellationToken) Array grouping over the objects of a subtree. Base implementation: the ids of the subtree (roots, de...
M ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>, CancellationToken) Execute COUNT for tree query through search_tree_objects_with_facets
M ExecuteTreeCountAsync<TProps>(TreeQueryContext<TProps>) Execute COUNT for tree query through search_tree_objects_with_facets
M ExecuteTreeToListAsync<TProps>(TreeQueryContext<TProps>, CancellationToken) Execute ToList for tree query through search_tree_objects_with_facets
M ExecuteTreeToListAsync<TProps>(TreeQueryContext<TProps>) Execute ToList for tree query through search_tree_objects_with_facets
M FirstNodeProbe<TProps>(TreeQueryContext<TProps>) The query cut to its first node, for : Take 1, and neither the
M GetFilterJsonAsync<TProps>(QueryContext<TProps>, CancellationToken) Returns the JSON filter that will be sent to SQL function (for diagnostics)
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>, CancellationToken) Get SQL preview for standard QueryContext (for IRedbQueryProvider compatibility)
M GetSqlPreviewAsync<TProps>(QueryContext<TProps>) Get SQL preview for standard QueryContext (for IRedbQueryProvider compatibility)
M GetSqlPreviewAsync<TProps>(TreeQueryContext<TProps>, CancellationToken) Returns SQL query for tree search that will be executed (for debugging)
M GetSqlPreviewAsync<TProps>(TreeQueryContext<TProps>) Returns SQL query for tree search that will be executed (for debugging)
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.
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