API Reference

C Agg redb.Core.Query.Aggregation

M Average<TKey, TProps, TValue>(IRedbGrouping<TKey, TProps>, Expression<Func<TProps, TValue>>) Average in a group: Agg.Average(g, x => x.Age)

M Max<TKey, TProps, TValue>(IRedbGrouping<TKey, TProps>, Expression<Func<TProps, TValue>>) Maximum in a group: Agg.Max(g, x => x.Price)

M Min<TKey, TProps, TValue>(IRedbGrouping<TKey, TProps>, Expression<Func<TProps, TValue>>) Minimum in a group: Agg.Min(g, x => x.Price)

M Sum<TKey, TProps, TValue>(IRedbGrouping<TKey, TProps>, Expression<Func<TProps, TValue>>) Sum in a group: Agg.Sum(g, x => x.Stock)

C AggregateResult redb.Core.Query.Aggregation

P Values Results by aliases

C ArithmeticExpression redb.Core.Query.QueryExpressions

T ArithmeticExpression(ValueExpression, ArithmeticOperator, ValueExpression) Arithmetic expression (Pro Only)

C ArrayLeaf redb.Core.Query.Filtering

P Value Value to compare against (for Contains, Count operations)

C BaseFilterExpressionParser redb.Core.Query.Parsing

M CreateExtendedComparison(BinaryExpression, ComparisonOperator, ValueExpression?, ValueExpression?) Extended comparison with ValueExpression (arithmetic/functions).

M ExtractPropertyAndValue(BinaryExpression) Extract property and value from binary expression.

M ExtractValueExpression(Expression) Recursively extract ValueExpression from any Expression.

M TryExtractValueExpression(Expression) Try to extract ValueExpression from Expression (arithmetic, functions).

C ComparisonExpression redb.Core.Query.QueryExpressions

P Value

C ConfigurationSource redb.Core.Models.Configuration

P Value Parameter value (as string for debugging)

C ConfigurationValidationError redb.Core.Models.Configuration

P CurrentValue

C ConstantValueExpression redb.Core.Query.QueryExpressions

T ConstantValueExpression(object?, Type) Constant value

P Value

C Contact redb.Examples.Models

P Value

C ContactDetail redb.Examples.Models

P Value

C CustomFunctionExpression redb.Core.Query.QueryExpressions

T CustomFunctionExpression(string, IReadOnlyList<ValueExpression>) Custom SQL function (Pro Only)

C E120_ListItemWhereByValue redb.Examples.Examples

C ExportFooter redb.Export.Models

P SequenceValue Value of the global_identity sequence at the time of export.

P TotalValues Total number of property-value records exported.

C FunctionCallExpression redb.Core.Query.QueryExpressions

T FunctionCallExpression(PropertyFunction, ValueExpression) Function call on value (Pro Only)

I IBulkOperations redb.Core.Data

M BulkDeleteValuesAsync(IEnumerable<long>) Bulk delete values by IDs.

M BulkDeleteValuesByListItemIdsAsync(IEnumerable<long>) Bulk delete values by ListItem IDs.

M BulkDeleteValuesByObjectIdsAsync(IEnumerable<long>) Bulk delete values by object IDs.

M BulkInsertValuesAsync(IEnumerable<RedbValue>) Bulk insert values using COPY protocol.

M BulkUpdateValuesAsync(IEnumerable<RedbValue>) Bulk update values.

I IDataProvider redb.Export.Providers

M GetSequenceValueAsync(CancellationToken) Returns the current value of the global_identity sequence.

M SetSequenceValueAsync(long, CancellationToken) Resets the global_identity sequence to the specified value

I IKeyGenerator redb.Core.Data

M NextValueIdAsync() Generate next unique ID for values.

M NextValueIdBatchAsync(int) Generate batch of value IDs for bulk operations.

I IListProvider redb.Core.Providers

M GetListItemByValueAsync(long, string)

C InExpression redb.Core.Query.QueryExpressions

P Values

I IPropertyMigrationBuilder<TProps, TProp> redb.Core.Pro.Migration

M DefaultValue(TProp) Default value for new field.

I IRedbContext redb.Core.Data

M NextValueIdAsync() Get next value ID.

M NextValueIdBatchAsync(int) Get batch of value IDs.

I IRedbList redb.Core.Models.Contracts

M FindItemByValue(string) Find item by value

I IRedbListItem redb.Core.Models.Contracts

P Value List item text value

I IRedbObject redb.Core.Models.Contracts

P ValueBool Primitive boolean value (for primitive schemas)

P ValueBytes Primitive byte array value (for primitive schemas)

P ValueDatetime Primitive datetime value (for primitive schemas)

P ValueDouble Primitive double value (for primitive schemas)

P ValueGuid Primitive GUID value (for primitive schemas)

P ValueLong Primitive long value (for primitive schemas)

P ValueNumeric Primitive decimal value (for primitive schemas)

P ValueString Primitive string value (for primitive schemas)

I IRedbQueryable<TProps> redb.Core.Query

M WhereIn<TValue>(Expression<Func<TProps, TValue>>, IEnumerable<TValue>) Filter by value in list (WHERE field IN (...)).

M WhereInRedb<TValue>(Expression<Func<IRedbObject, TValue>>, IEnumerable<TValue>) Filter by IRedbObject base field in list (WHERE _field IN (...)).

I IRedbStructure redb.Core.Models.Contracts

P DefaultValue Default value (in binary form)

I ISqlDialect redb.Core.Query

M ListItems_SelectByListIdAndValue() SELECT list item by list ID and value. Params: $1=listId, $2=value

M ObjectStorage_DeleteValuesByObjectId() DELETE all values for object. Params: $1=objectId

M ObjectStorage_SelectValueById() SELECT single value by ID. Params: $1=valueId

M ObjectStorage_SelectValuesForObjects() SELECT all values for object IDs (ChangeTracking). Params: $1=objectIds (array)

M ObjectStorage_SelectValuesWithTypes() SELECT existing values with types. Params: $1=objectId, $2=structureIds (array)

M Tree_DeleteValuesByObjectIds() DELETE values by object IDs. Params: $1=objectIds (array)

I ISqlDialectPro redb.Core.Pro.Query

M Materialization_SelectValuesByObjectAndStructureIds() Bulk select values by object IDs and structure IDs.

M Materialization_SelectValuesByObjectIds() Bulk select values by object IDs.

C JsonValueConverter redb.Core.Query.Utils

E ListItemProperty redb.Core.Query.Models

T Value Status.Value → JOIN _list_items._value

C ListItemRecord redb.Export.Models

P Value Display value of the list item.

C ListProviderBase redb.Core.Providers.Base

M GetListItemByValueAsync(long, string)

C MigrationExpressionCompiler redb.Core.Pro.Migration

M CompileDefaultValueAsync(long, string, object?) Compile DefaultValue to UPDATE SQL

E MigrationType redb.Core.Pro.Migration

T DefaultValue

C MsSqlDialect redb.MSSql.Sql

M ListItems_SelectByListIdAndValue() SELECT list item by list ID and value. Params: $1=listId, $2=value

M ObjectStorage_DeleteValuesByObjectId() DELETE all values for object. Params: $1=objectId

M ObjectStorage_SelectValueById() SELECT single value by ID. Params: $1=valueId

M ObjectStorage_SelectValuesForObjects() SELECT all values for object IDs (ChangeTracking). Params: $1=objectIds (array)

M ObjectStorage_SelectValuesWithTypes() SELECT existing values with types. Params: $1=objectId, $2=structureIds (array)

M Tree_DeleteValuesByObjectIds() DELETE values by object IDs. Params: $1=objectIds (array)

C MssqlProvider redb.Export.Providers

M GetSequenceValueAsync(CancellationToken) Returns the current value of the global_identity sequence.

M SetSequenceValueAsync(long, CancellationToken) Resets the global_identity sequence to the specified value

C NpgsqlBulkOperations redb.Postgres.Data

M BulkDeleteValuesAsync(IEnumerable<long>) Bulk delete values by IDs.

M BulkDeleteValuesByListItemIdsAsync(IEnumerable<long>) Bulk delete values by ListItem IDs.

M BulkDeleteValuesByObjectIdsAsync(IEnumerable<long>) Bulk delete values by object IDs.

M BulkInsertValuesAsync(IEnumerable<RedbValue>) Bulk insert values using COPY protocol.

M BulkUpdateValuesAsync(IEnumerable<RedbValue>) Bulk update values using UPDATE FROM VALUES.

C ObjectRecord redb.Export.Models

P ValueBool Inline value (for primitive schemes).

P ValueBytes Inline binary value (for primitive schemes).

P ValueDatetime Inline value (for primitive schemes).

P ValueDouble Inline value (for primitive schemes).

P ValueGuid Inline value (for primitive schemes).

P ValueLong Inline value (for primitive schemes).

P ValueNumeric Inline value (for primitive schemes).

P ValueString Inline value (for primitive schemes).

C ObjectStorageProviderBase redb.Core.Providers.Base

T _pendingValuesToDelete Value IDs to delete (from ChangeTracking diff). Pro only.

T _pendingValuesToInsert Values to insert (from ChangeTracking diff). Pro only.

T _pendingValuesToUpdate Values to update (from ChangeTracking diff). Pro only.

M ExecuteBatchByStrategy(EavSaveStrategy, List<IRedbObject>, List<RedbValue>) Executes batch save by strategy. OpenSource: only DeleteInsert.

M PrepareValuesByStrategy(List<IRedbObject>, List<RedbValue>, bool) Step 6: Strategy selection for values processing.

M PrepareValuesWithTreeDeleteInsert(List<IRedbObject>, List<RedbValue>) DeleteInsert strategy: delete all existing values, then insert new ones.

M ProcessAllObjectsPropertiesRecursively(List<IRedbObject>, List<RedbValue>) 🔄 STEP 5: Recursive processing of Props of all objects → RedbValue lists

M SaveBatchWithDeleteInsertStrategy(List<IRedbObject>, List<RedbValue>) DeleteInsert batch strategy: delete ALL values, BulkInsert/BulkUpdate of objects, BulkInsert of valu...

M UpdateExistingValueFields(RedbValue, RedbValue, Dictionary<long, string>) Updates existing value fields from new value (only significant fields).

C OrderingExpression redb.Core.Query.QueryExpressions

T OrderingExpression(PropertyInfo, SortDirection, ValueExpression?) Sorting information.

C PostgresProvider redb.Export.Providers

M GetSequenceValueAsync(CancellationToken) Returns the current value of the global_identity sequence.

M SetSequenceValueAsync(long, CancellationToken) Resets the global_identity sequence to the specified value

C PostgreSqlDialect redb.Postgres.Sql

M ListItems_SelectByListIdAndValue() SELECT list item by list ID and value. Params: $1=listId, $2=value

M ObjectStorage_DeleteValuesByObjectId() DELETE all values for object. Params: $1=objectId

M ObjectStorage_SelectValueById() SELECT single value by ID. Params: $1=valueId

M ObjectStorage_SelectValuesForObjects() SELECT all values for object IDs (ChangeTracking). Params: $1=objectIds (array)

M ObjectStorage_SelectValuesWithTypes() SELECT existing values with types. Params: $1=objectId, $2=structureIds (array)

M Tree_DeleteValuesByObjectIds() DELETE values by object IDs. Params: $1=objectIds (array)

C ProMsSqlDialect redb.MSSql.Pro.Sql

M Materialization_SelectValuesByObjectAndStructureIds() Bulk select values by object IDs and structure IDs.

M Materialization_SelectValuesByObjectIds() Bulk select values by object IDs.

C ProObjectStorageProviderBase redb.Core.Pro.Providers

M AlignArrayBaseRecords(List<ValueTreeNode>, List<ValueTreeNode>, List<RedbValue>) Aligns array base record IDs between old and new trees.

M CloneRValue(RedbValue) Deep copy RedbValue for data isolation in parallel context.

M ExecuteBatchByStrategy(EavSaveStrategy, List<IRedbObject>, List<RedbValue>) Pro: Batch strategy with ChangeTracking support.

M PrepareValuesByStrategy(List<IRedbObject>, List<RedbValue>, bool) Pro: Full strategy support including ChangeTracking.

C PropertyMetadata redb.PropsEditor.Services

M GetValue(object) Gets the value of this property from an object.

M SetValue(object, object?) Sets the value of this property on an object.

C PropertyMigrationBuilder<TProps, TProp> redb.Core.Pro.Migration

M DefaultValue(TProp) Default value for new field.

C PropertyMigrationConfig redb.Core.Pro.Migration

P DefaultValue

C PropertyValueExpression redb.Core.Query.QueryExpressions

T PropertyValueExpression(PropertyInfo) Reference to object property

C ProPostgreSqlDialect redb.Postgres.Pro.Sql

M Materialization_SelectValuesByObjectAndStructureIds() Bulk select values by object IDs and structure IDs.

M Materialization_SelectValuesByObjectIds() Bulk select values by object IDs.

C ProPropsMaterializer redb.Core.Pro.Materialization

M GetObjectProps<TProps>(long, List<RedbValue>, long, int, ConcurrentBag<long>) Analog of get_object_json - works with values from MEMORY!

C ProSqlBuilder redb.MSSql.Pro.Query

M BuildPropsValueSubquery(FieldInfo, string, int?) Generates subquery for getting Props value.

M FormatValueLegacy(object?) Formats value for SQL (legacy, without parameters).

C ProSqlBuilder redb.Postgres.Pro.Query

M BuildPropsValueSubquery(FieldInfo, string, int?) Generates subquery for getting Props value

M FormatValueLegacy(object?)

C RedbContextBase redb.Core.Data

M NextValueIdAsync() Get next value ID.

M NextValueIdBatchAsync(int) Get batch of value IDs.

C RedbKeyGeneratorBase redb.Core.Data

M NextValueIdAsync() Get next value ID (uses shared static cache).

M NextValueIdBatchAsync(int) Get batch of value IDs.

C RedbList redb.Core.Models.Entities

M FindItemByValue(string) Find item by value.

C RedbListItem redb.Core.Models.Entities

M GetDisplayValue() Get display value.

P Value Item value.

C RedbObject redb.Core.Models.Entities

P value_bool

P value_bytes

P value_datetime

P value_double

P value_guid

P value_long

P value_numeric

P value_string

P ValueBool Primitive boolean value (for primitive schemas)

P ValueBytes Primitive byte array value (for primitive schemas)

P ValueDatetime Primitive datetime value (for primitive schemas)

P ValueDouble Primitive double value (for primitive schemas)

P ValueGuid Primitive GUID value (for primitive schemas)

P ValueLong Primitive long value (for primitive schemas)

P ValueNumeric Primitive decimal value (for primitive schemas)

P ValueString Primitive string value (for primitive schemas)

C RedbObjectRow redb.Core.Models.Entities

P ValueBool Boolean value stored directly in object row.

P ValueBytes Binary data stored directly in object row.

P ValueDatetime DateTime value stored directly in object row.

P ValueDouble Double value stored directly in object row.

P ValueGuid Guid value stored directly in object row.

P ValueLong Long value stored directly in object row.

P ValueNumeric Numeric/decimal value stored directly in object row.

P ValueString String value stored directly in object row.

C RedbQueryable<TProps> redb.Core.Query

M WhereIn<TValue>(Expression<Func<TProps, TValue>>, IEnumerable<TValue>) Filter by value in list (WHERE field IN (...)).

M WhereInRedb<TValue>(Expression<Func<IRedbObject, TValue>>, IEnumerable<TValue>) Filter by IRedbObject base field in list (WHERE _field IN (...)).

C RedbStructure redb.Core.Models.Entities

P DefaultValue Default value (binary).

C RedbTypeMapping redb.Core.Utils

M GetObjectValueColumn(long) Get _objects column name for RedbPrimitive value storage

M GetValueColumn(long) Get _values column name for type ID

M RequiresValuesRecords(long) Check if type requires _values records (vs direct storage in _objects.value*)

C RedbValue redb.Core.Models.Entities

T RedbValue() Default constructor for deserialization and mapping.

C SchemeMetadataCacheRow redb.Core.Pro.Models

P DefaultValue

C SqlBulkOperations redb.MSSql.Data

M BulkDeleteValuesAsync(IEnumerable<long>) Bulk delete values by IDs.

M BulkDeleteValuesByListItemIdsAsync(IEnumerable<long>) Bulk delete values by ListItem IDs.

M BulkDeleteValuesByObjectIdsAsync(IEnumerable<long>) Bulk delete values by object IDs.

M BulkInsertValuesAsync(IEnumerable<RedbValue>) Bulk insert values using SqlBulkCopy.

M BulkUpdateValuesAsync(IEnumerable<RedbValue>) Bulk update values using MERGE statement.

C SqlParameterCollectorBase redb.Core.Query.Parameters

M NormalizeValue(object?) Normalizes value before adding to parameters.

C StructureChange redb.Core.Providers

P NewValue

P OldValue

C StructureRecord redb.Export.Models

P DefaultValue Serialized default value.

C TreeFilter redb.Core.Query.Base

P Value

C TreeQueryableBase<TProps> redb.Core.Query.Base

M WhereIn<TValue>(Expression<Func<TProps, TValue>>, IEnumerable<TValue>) Filter by value in list (WHERE field IN (...)).

M WhereInRedb<TValue>(Expression<Func<IRedbObject, TValue>>, IEnumerable<TValue>) Filter by IRedbObject base field in list (WHERE _field IN (...)).

C UserSearchCriteria redb.Core.Models.Users

P CodeGuidValue Filter by GUID code (exact match, rarely used)

P CodeIntValue Filter by integer code (exact match)

P KeyValue Filter by user key (exact match)

C ValueExpression redb.Core.Query.QueryExpressions

C ValueRecord redb.Export.Models

C ValuesTopologicalSort redb.Core.Utils

M SortByFkDependency(List<RedbValue>) Sort values by ArrayParentId dependencies (single-threaded).

C ValuesTopologicalSort redb.Postgres.Utils

M SortByFkDependency(List<RedbValue>) Sort values by ArrayParentId dependencies (single-threaded).

C ValueTreeBuilder redb.Core.Pro.ChangeTracking

M BuildTreeFromDB(List<RedbValue>, List<StructureTreeNode>) Build tree from DB (existing data).

M BuildTreeFromMemory(IRedbObject, List<StructureTreeNode>, Func<IRedbObject, List<StructureTreeNode>, List<RedbValue>, List<IRedbObject>, Task>) Build tree from memory (new data).

M PrintTree(List<ValueTreeNode>, int) Diagnostics: print tree to string.

C ValueTreeDiff redb.Core.Pro.ChangeTracking

M CompareTreesWithHash(List<ValueTreeNode>, List<ValueTreeNode>) Compare two trees using hashes for optimization.

C ValueTreeNode redb.Core.Pro.ChangeTracking

P Value

C ValueTupleDictionaryConverter<TKey, TValue> redb.Core.Serialization

M Write(Utf8JsonWriter, Dictionary<TKey, TValue>?, JsonSerializerOptions) Writes a specified value as JSON.

C ValueTupleDictionaryConverterFactory redb.Core.Serialization

C Win redb.Core.Query.Aggregation

M FirstValue<T>(T) FIRST_VALUE(field) OVER (...)

M LastValue<T>(T) LAST_VALUE(field) OVER (...)

RedBase Documentation