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: Function Clear search
E AggregateFunction redb.Core.Query.Aggregation
C AggregateRequest redb.Core.Query.Aggregation
P Function Aggregation function
C AggregationInfo redb.Core.Query.Projection
P Function
C BaseFilterExpressionParser redb.Core.Query.Parsing
M CreateCustomFunctionExpression(MethodCallExpression)
M CreateDateTimeFunctionExpression(MemberExpression)
M CreateFunctionCallExpression(MethodCallExpression)
M IsCustomFunctionCall(MethodCallExpression)
M IsProFunctionCall(MethodCallExpression)
C CustomFunctionExpression redb.Core.Query.QueryExpressions
T CustomFunctionExpression(string, IReadOnlyList<ValueExpression>) Custom SQL function (Pro Only)
P FunctionName
C E161_SqlFunctionCoalesce redb.Examples.Examples
C E162_SqlFunctionPower redb.Examples.Examples
C E163_SqlFunctionNested redb.Examples.Examples
C FunctionCallExpression redb.Core.Query.QueryExpressions
P Function
T FunctionCallExpression(PropertyFunction, ValueExpression) Function call on value (Pro Only)
I IRedbQueryProvider redb.Core.Query
M ExecuteAggregateAsync(long, string, AggregateFunction, FilterExpression?) Execute single-field aggregation with FilterExpression (Pro version).
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) Execute aggregation on EAV field (SQL strategy for simple fields).
I ISqlDialect redb.Core.Query
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_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_SqlPreviewBaseFunction() SQL preview function name for base (lazy loading) search.
M Query_SqlPreviewFunction() SQL preview function name for regular search.
M Query_TreeSqlPreviewBaseFunction() SQL preview function name for tree base (lazy loading) search.
M Query_TreeSqlPreviewFunction() SQL preview function name for tree search.
C MsSqlDialect redb.MSSql.Sql
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_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_SqlPreviewBaseFunction() SQL preview function name for base (lazy loading) search.
M Query_SqlPreviewFunction() SQL preview function name for regular search.
M Query_TreeSqlPreviewBaseFunction() SQL preview function name for tree base (lazy loading) search.
M Query_TreeSqlPreviewFunction() SQL preview function name for tree search.
C PostgreSqlDialect redb.Postgres.Sql
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_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_SqlPreviewBaseFunction() SQL preview function name for base (lazy loading) search.
M Query_SqlPreviewFunction() SQL preview function name for regular search.
M Query_TreeSqlPreviewBaseFunction() SQL preview function name for tree base (lazy loading) search.
M Query_TreeSqlPreviewFunction() SQL preview function name for tree search.
E ProFeatureCategory redb.Core.Exceptions
T SqlFunction Custom SQL functions via Sql.Function().
T WindowFunction Window functions with GroupBy.
E PropertyFunction redb.Core.Query.QueryExpressions
C PropertyInfo redb.Core.Query.QueryExpressions
P Function Optional: function applied to property (Length, Count)
T PropertyInfo(string, Type, bool, PropertyFunction?) Field information in expression
C ProQueryProvider redb.MSSql.Pro.Query
M ExecuteAggregateAsync(long, string, AggregateFunction, FilterExpression?) ⚡ Pro: Single field aggregation with FilterExpression (preferred).
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) ⚡ Pro: Single field aggregation with filterJson (legacy).
M GetSingleAggregateSqlPreviewAsync(long, string, AggregateFunction, FilterExpression?) Pro: SQL Preview for Single Aggregation
C ProQueryProvider redb.Postgres.Pro.Query
M ExecuteAggregateAsync(long, string, AggregateFunction, FilterExpression?) ⚡ Pro: Single field aggregation with FilterExpression (preferred).
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) ⚡ Pro: Single field aggregation with filterJson (legacy).
M GetSingleAggregateSqlPreviewAsync(long, string, AggregateFunction, FilterExpression?) Pro: SQL Preview for Single Aggregation
C ProSqlBuilder redb.MSSql.Pro.Query
M ApplyFunction(PropertyFunction, string) Pro: Apply SQL function to column (T-SQL syntax).
M ApplyPropertyFunction(string, PropertyFunction?) Applies property function to column.
M BuildAggregateSelectColumn(AggregateFunction, string, string, IReadOnlyDictionary<string, FieldInfo>, SqlParameterCollector, int?) Generates full aggregation column (for SELECT).
C ProSqlBuilder redb.Postgres.Pro.Query
M ApplyFunction(PropertyFunction, string) Pro: Apply SQL function to column
M ApplyPropertyFunction(string, PropertyFunction?)
M BuildAggregateSelectColumn(AggregateFunction, string, string, IReadOnlyDictionary<string, FieldInfo>, SqlParameterCollector, int?) Generates full aggregation column (for SELECT)
M MapAggregateFunction(AggregateFunction) Mapping AggregateFunction → SQL function
C ProSqlBuilderBase redb.Core.Pro.Query
M MapAggregateFunction(AggregateFunction) Maps aggregate function to SQL function name.
C ProTreeQueryProvider redb.MSSql.Pro.Query
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) Execute aggregation on EAV field (SQL strategy for simple fields).
C ProTreeQueryProvider redb.Postgres.Pro.Query
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) Execute aggregation on EAV field (SQL strategy for simple fields).
C QueryProviderBase redb.Core.Query.Base
M ExecuteAggregateAsync(long, string, AggregateFunction, FilterExpression?) Execute single-field aggregation with FilterExpression (Pro version).
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) Perform aggregation on EAV field (SQL strategy)
C Sql redb.Core.Query
M Function<TResult>(string, params object?[]) Call custom SQL function.
C TreeQueryProviderBase redb.Core.Query.Base
M ExecuteAggregateAsync(long, string, AggregateFunction, FilterExpression?) Execute single-field aggregation with FilterExpression (Pro version).
M ExecuteAggregateAsync(long, string, AggregateFunction, string?) Execute aggregation on EAV field (SQL strategy for simple fields).