API Reference

C BaseFilterExpressionParser redb.Core.Query.Parsing

M ParseRedbFilter(Expression<Func<IRedbObject, bool>>) Parse LINQ predicate for base RedbObject fields (id, name, parent_id, etc.).

C GlobalPropsCache redb.Core.Caching

M FilterNeedToLoad<TProps>(List<(long objectId, Guid hash)>, out Dictionary<long, RedbObject<TProps>>) BULK: determine which objects need to be loaded from DB (set difference).

M Initialize(IRedbObjectCache) Initialize cache for this domain (called once at application startup per domain).

M Set<TProps>(RedbObject<TProps>) Save WHOLE RedbObject to cache.

I IBulkOperations redb.Core.Data

M BulkInsertObjectsAsync(IEnumerable<RedbObjectRow>) Bulk insert objects using COPY protocol.

M BulkUpdateObjectsAsync(IEnumerable<RedbObjectRow>) Bulk update objects.

I IFilterExpressionParser redb.Core.Query.QueryExpressions

M ParseRedbFilter(Expression<Func<IRedbObject, bool>>) Parse lambda expression for filtering by base IRedbObject fields

I ILazyPropsLoader redb.Core.Providers

M LoadPropsForManyAsync<TProps>(List<RedbObject<TProps>>, HashSet<long>?, int?) OPTIMIZED Props loading with structure_ids filter and custom depth.

M LoadPropsForManyAsync<TProps>(List<RedbObject<TProps>>, HashSet<long>?) OPTIMIZED Props loading with structure_ids filter.

M LoadPropsForManyAsync<TProps>(List<RedbObject<TProps>>, int?) BULK Props loading with custom depth for nested RedbObject.

M LoadPropsForManyAsync<TProps>(List<RedbObject<TProps>>) BULK Props loading for multiple objects with caching and parallelism.

I IObjectStorageProvider redb.Core.Providers

M AddNewObjectsAsync<TProps>(IEnumerable<IRedbObject<TProps>>, IRedbUser) BULK INSERT with explicit user: Create many new objects (does NOT check permissions).

M AddNewObjectsAsync<TProps>(IEnumerable<IRedbObject<TProps>>) BULK INSERT: Create many new objects in one operation (does NOT check permissions).

M DeleteAsync(IEnumerable<IRedbObject>, IRedbUser) Bulk delete objects by interface with explicit user (uses config.DefaultCheckPermissionsOnDelete).

M DeleteAsync(IEnumerable<IRedbObject>) Bulk delete objects by interface (uses _securityContext and config.DefaultCheckPermissionsOnDelete).

M DeleteAsync(IRedbObject, IRedbUser) Delete object with explicit user (uses config.DefaultCheckPermissionsOnDelete).

M DeleteAsync(IRedbObject) Delete object (uses _securityContext and config.DefaultCheckPermissionsOnDelete).

M LoadAsync<TProps>(IRedbObject, int, bool?) Load object from EAV (uses _securityContext and config.DefaultCheckPermissionsOnLoad).

M LoadAsync<TProps>(IRedbObject, IRedbUser, int, bool?) Load object from EAV with explicit user (uses config.DefaultCheckPermissionsOnLoad).

M LoadWithParentsAsync<TProps>(IRedbObject, int, bool?) Load object from EAV with parent chain to root (uses _securityContext).

M LoadWithParentsAsync<TProps>(IRedbObject, IRedbUser, int, bool?) Load object from EAV with parent chain to root with explicit user.

M SaveAsync(IEnumerable<IRedbObject>, IRedbUser) Bulk save of polymorphic objects with explicit user (uses config).

M SaveAsync(IEnumerable<IRedbObject>) Bulk save of polymorphic objects (uses _securityContext and config).

M SaveAsync(IRedbObject, IRedbUser) Save object to EAV with explicit user. Determines type internally.

M SaveAsync(IRedbObject) Save object to EAV (uses _securityContext and config.DefaultCheckPermissionsOnSave).

M SaveAsync<TProps>(IRedbObject<TProps>, IRedbUser) Save generic object to EAV with explicit user (uses config.DefaultCheckPermissionsOnSave).

M SaveAsync<TProps>(IRedbObject<TProps>) Save generic object to EAV (uses _securityContext and config.DefaultCheckPermissionsOnSave).

M SoftDeleteAsync(IEnumerable<IRedbObject>, IRedbUser, long?) Mark objects for soft-deletion with explicit user.

M SoftDeleteAsync(IEnumerable<IRedbObject>, long?) Mark objects for soft-deletion (uses _securityContext).

I IOrderedRedbQueryable<TProps> redb.Core.Query

M ThenByDescendingRedb<TKey>(Expression<Func<IRedbObject, TKey>>) Additional descending sort by IRedbObject base fields.

M ThenByRedb<TKey>(Expression<Func<IRedbObject, TKey>>) Additional ascending sort by IRedbObject base fields.

I IOrderingExpressionParser redb.Core.Query.QueryExpressions

M ParseRedbOrdering<TKey>(Expression<Func<IRedbObject, TKey>>, SortDirection) 🆕 Parse sorting expression by base IRedbObject fields (id, name, date_create, etc.)

I IPermissionProvider redb.Core.Providers

M CanUserDeleteObject(IRedbObject, IRedbUser) Check if user can delete object.

M CanUserDeleteObject(IRedbObject) Check if current user can delete object.

M CanUserDeleteObject(RedbObject, IRedbUser) Check if user can delete object.

M CanUserDeleteObject(RedbObject) Check if current user can delete object.

M CanUserEditObject(IRedbObject, IRedbUser) Check if user can edit object.

M CanUserEditObject(IRedbObject) Check if current user can edit object.

M CanUserEditObject(RedbObject, IRedbUser) Check if user can edit object.

M CanUserEditObject(RedbObject) Check if current user can edit object.

M CanUserInsertScheme(RedbObject, IRedbUser) Check if user can create objects in object's scheme.

M CanUserSelectObject(IRedbObject, IRedbUser) Check if user can read object.

M CanUserSelectObject(IRedbObject) Check if current user can read object.

M CanUserSelectObject(RedbObject, IRedbUser) Check if user can read object.

M CanUserSelectObject(RedbObject) Check if current user can read object.

M GetEffectivePermissionsAsync(IRedbUser, IRedbObject) Get effective user permissions for object (including inheritance and roles).

M GetEffectivePermissionsBatchAsync(IRedbUser, IRedbObject[]) Get effective user permissions for multiple objects (batch).

M GetPermissionsByObjectAsync(IRedbObject) Get permissions for object.

M GrantPermissionAsync(IRedbRole, IRedbObject, PermissionAction, IRedbUser?) Grant permission to role.

M GrantPermissionAsync(IRedbUser, IRedbObject, PermissionAction, IRedbUser?) Grant permission to user.

M RevokePermissionAsync(IRedbRole, IRedbObject, IRedbUser?) Revoke permission from role.

M RevokePermissionAsync(IRedbUser, IRedbObject, IRedbUser?) Revoke permission from user.

I IPropsMaterializer redb.Core.Materialization

M MaterializeManyAsync<TProps>(IReadOnlyList<IRedbObject>, IEnumerable<long>?) Batch materialize Props for multiple objects.

I IQueryableProvider redb.Core.Providers

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>(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).

I IRedbList redb.Core.Models.Contracts

M AddItem(string, IRedbObject, string?) Add item to list with linked object (Aggregate Root pattern)

M CreateItem(string, IRedbObject, string?) Create item for list with linked object

I IRedbObject redb.Core.Models.Contracts

I IRedbObject<TProps> redb.Core.Models.Contracts

I IRedbObjectCache redb.Core.Caching

M FilterNeedToLoad<TProps>(List<(long objectId, Guid hash)>, out Dictionary<long, RedbObject<TProps>>) BULK: determine which objects need to be loaded from DB (set difference)

M Set<TProps>(RedbObject<TProps>) Save WHOLE RedbObject to cache

I IRedbObjectSerializer redb.Core.Serialization

I IRedbQueryable<TProps> redb.Core.Query

M AggregateAsync<TResult>(Expression<Func<RedbObject<TProps>, TResult>>) Flexible aggregation - choose what to aggregate via Agg.Sum/Avg/Min/Max/Count.

M AggregateRedbAsync<TResult>(Expression<Func<IRedbObject, TResult>>) Flexible aggregation for IRedbObject base fields ONLY.

M AverageRedbAsync<TField>(Expression<Func<IRedbObject, TField>>) Average of IRedbObject base field values.

M DistinctByRedb<TKey>(Expression<Func<IRedbObject, TKey>>) DISTINCT ON (base_field) - one object per unique IRedbObject base field value.

M GroupByRedb<TKey>(Expression<Func<IRedbObject, TKey>>) Group by IRedbObject base fields (id, scheme_id, parent_id, etc.).

M MaxRedbAsync<TField>(Expression<Func<IRedbObject, TField>>) Maximum IRedbObject base field value (ValueLong, Key, DateCreate, etc.).

M MinRedbAsync<TField>(Expression<Func<IRedbObject, TField>>) Minimum IRedbObject base field value (ValueLong, Key, DateCreate, etc.).

M OrderByDescendingRedb<TKey>(Expression<Func<IRedbObject, TKey>>) Sort descending by IRedbObject base fields.

M OrderByRedb<TKey>(Expression<Func<IRedbObject, TKey>>) Sort ascending by IRedbObject base fields (id, name, date_create, etc.).

M Select<TResult>(Expression<Func<RedbObject<TProps>, TResult>>) Project fields - return only selected properties.

M SumRedbAsync<TField>(Expression<Func<IRedbObject, TField>>) Sum of IRedbObject base field values (ValueLong, Key, etc.).

M WhereChildrenOf(IRedbObject) Direct children of specified object.

M WhereDescendantsOf(IRedbObject, int?) All descendants of specified object (recursive).

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

M WhereRedb(Expression<Func<IRedbObject, bool>>) Filter by base object fields (Id, Name, ParentId, etc.).

I IRedbWindowedQueryable<TProps> redb.Core.Query.Window

M SelectAsync<TResult>(Expression<Func<RedbObject<TProps>, TResult>>) Projection with window functions.

M ToSqlStringAsync<TResult>(Expression<Func<RedbObject<TProps>, TResult>>) Returns SQL string for debugging (like EF Core ToQueryString).

I ITreeProvider redb.Core.Providers

M CreateChildAsync<TProps>(TreeRedbObject<TProps>, IRedbObject, IRedbUser) Create child object with explicit user (uses config.DefaultCheckPermissionsOnSave).

M CreateChildAsync<TProps>(TreeRedbObject<TProps>, IRedbObject) Create child object (uses _securityContext and config.DefaultCheckPermissionsOnSave).

M DeleteSubtreeAsync(IRedbObject, IRedbUser) Delete object subtree recursively with explicit user (uses config.DefaultCheckPermissionsOnDelete).

M DeleteSubtreeAsync(IRedbObject) Delete object subtree recursively (uses _securityContext and config.DefaultCheckPermissionsOnDelete)...

M GetChildrenAsync<TProps>(IRedbObject, IRedbUser) Get direct children of object with explicit user (uses config.DefaultCheckPermissionsOnLoad).

M GetChildrenAsync<TProps>(IRedbObject) Get direct children of object (uses _securityContext and config.DefaultCheckPermissionsOnLoad).

M GetDescendantsAsync<TProps>(IRedbObject, int?) Get all object descendants (uses _securityContext and config.DefaultCheckPermissionsOnLoad).

M GetDescendantsAsync<TProps>(IRedbObject, IRedbUser, int?) Get all object descendants with explicit user (uses config.DefaultCheckPermissionsOnLoad).

M GetPathToRootAsync<TProps>(IRedbObject, IRedbUser) Get path from object to root with explicit user (uses config.DefaultCheckPermissionsOnLoad).

M GetPathToRootAsync<TProps>(IRedbObject) Get path from object to root (uses _securityContext and config.DefaultCheckPermissionsOnLoad).

M GetPolymorphicChildrenAsync(IRedbObject, IRedbUser) Get all direct children of object regardless of their schemes with explicit user.

M GetPolymorphicChildrenAsync(IRedbObject) Get all direct children of object regardless of their schemes.

M GetPolymorphicDescendantsAsync(IRedbObject, int?) Get all polymorphic descendants of object regardless of their schemes.

M GetPolymorphicDescendantsAsync(IRedbObject, IRedbUser, int?) Get all polymorphic descendants of object with explicit user.

M GetPolymorphicPathToRootAsync(IRedbObject, IRedbUser) Get polymorphic path from object to root with explicit user.

M GetPolymorphicPathToRootAsync(IRedbObject) Get polymorphic path from object to root - objects can be of different schemes.

M LoadPolymorphicTreeAsync(IRedbObject, int?) Load polymorphic tree/subtree - supports objects of different schemes in one tree.

M LoadPolymorphicTreeAsync(IRedbObject, IRedbUser, int?) Load polymorphic tree/subtree with explicit user.

M LoadTreeAsync<TProps>(IRedbObject, int?) Load tree/subtree (uses _securityContext and config.DefaultCheckPermissionsOnLoad).

M LoadTreeAsync<TProps>(IRedbObject, IRedbUser, int?) Load tree/subtree with explicit user (uses config.DefaultCheckPermissionsOnLoad).

M MoveObjectAsync(IRedbObject, IRedbObject?, IRedbUser) Move object in tree with explicit user (uses config.DefaultCheckPermissionsOnSave).

M MoveObjectAsync(IRedbObject, IRedbObject?) Move object in tree (uses _securityContext and config.DefaultCheckPermissionsOnSave).

I ITreeRedbObject redb.Core.Models.Contracts

M IsAncestorOf(ITreeRedbObject) Checks if current node is ancestor of specified node

M IsDescendantOf(ITreeRedbObject) Checks if current node is descendant of specified node

I ITreeRedbObject<TProps> redb.Core.Models.Contracts

I IWindowSpec<TProps> redb.Core.Query.Window

M OrderByDescRedb<TKey>(Expression<Func<IRedbObject, TKey>>) Sort within window by IRedbObject base field (descending).

M OrderByRedb<TKey>(Expression<Func<IRedbObject, TKey>>) Sort within window by IRedbObject base field (ascending).

M PartitionByRedb<TKey>(Expression<Func<IRedbObject, TKey>>) Partition by IRedbObject base field (SchemeId, OwnerId, etc.).

C LazyPropsLoader redb.MSSql.Providers

T LazyPropsLoader(IRedbContext, ISchemeSyncProvider, IRedbObjectSerializer, RedbServiceConfiguration, IListProvider?, ILogger?)

M LoadPropsForManyAsync<TProps>(List<RedbObject<TProps>>, HashSet<long>?, int?) BULK Props loading with projection filter and custom depth.

M LoadPropsForManyAsync<TProps>(List<RedbObject<TProps>>, HashSet<long>?) BULK Props loading with projection filter (for Select projections).

M LoadPropsForManyAsync<TProps>(List<RedbObject<TProps>>, int?) BULK Props loading with custom depth for nested RedbObject.

M LoadPropsForManyAsync<TProps>(List<RedbObject<TProps>>) BULK Props loading for multiple objects via get_object_json batch.

M LoadPropsForManyPolymorphicAsync(List<IRedbObject>) BULK loading for polymorphic objects (different schemes).

C LazyPropsLoader redb.Postgres.Providers

T LazyPropsLoader(IRedbContext, ISchemeSyncProvider, IRedbObjectSerializer, RedbServiceConfiguration, IListProvider?, ILogger?)

M LoadPropsForManyAsync<TProps>(List<RedbObject<TProps>>, HashSet<long>?, int?) BULK Props loading with projection filter and custom depth.

M LoadPropsForManyAsync<TProps>(List<RedbObject<TProps>>, HashSet<long>?) BULK Props loading with projection filter (for Select projections).

M LoadPropsForManyAsync<TProps>(List<RedbObject<TProps>>, int?) BULK Props loading with custom depth for nested RedbObject.

M LoadPropsForManyAsync<TProps>(List<RedbObject<TProps>>) BULK Props loading for multiple objects via get_object_json batch.

M LoadPropsForManyPolymorphicAsync(List<IRedbObject>) BULK loading for polymorphic objects (different schemes).

C MemoryRedbObjectCache redb.Core.Caching

M FilterNeedToLoad<TProps>(List<(long objectId, Guid hash)>, out Dictionary<long, RedbObject<TProps>>) BULK: determine which objects need to be loaded from DB.

T MemoryRedbObjectCache(int, TimeSpan?, Func<long>?, Func<long, Task<int?>>?, ILogger?) Constructor.

M Set<TProps>(RedbObject<TProps>) Save WHOLE RedbObject to cache

C MssqlObjectStorageProvider redb.MSSql.Providers

T MssqlObjectStorageProvider(IRedbContext, IRedbObjectSerializer, IPermissionProvider, IRedbSecurityContext, ISchemeSyncProvider, RedbServiceConfiguration, IListProvider?, ILogger?) Creates a new MssqlObjectStorageProvider instance.

C MssqlQueryableProvider redb.MSSql.Providers

M CreateMultiRootTreeQuery<TProps>(long, long?, bool, List<IRedbObject>, int?) Create tree query for multiple root objects.

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 MssqlTreeProvider redb.MSSql.Providers

T MssqlTreeProvider(IRedbContext, IObjectStorageProvider, IPermissionProvider, IRedbObjectSerializer, IRedbSecurityContext, ISchemeSyncProvider, RedbServiceConfiguration?, ILogger?) Creates MSSQL tree provider with default MsSqlDialect.

C MssqlTreeQueryProvider redb.MSSql.Query

T MssqlTreeQueryProvider(IRedbContext, IRedbObjectSerializer, ILazyPropsLoader?, RedbServiceConfiguration?, ILogger?, ISqlDialect?, string?, ISchemeSyncProvider?)

C NpgsqlBulkOperations redb.Postgres.Data

M BulkInsertObjectsAsync(IEnumerable<RedbObjectRow>) Bulk insert objects using COPY protocol.

M BulkUpdateObjectsAsync(IEnumerable<RedbObjectRow>) Bulk update objects using UPDATE FROM VALUES.

C ObjectStorageProviderBase redb.Core.Providers.Base

M AddNewObjectsAsync<TProps>(IEnumerable<IRedbObject<TProps>>, IRedbUser) 🚀 BULK INSERT with explicit user: Create multiple new objects (WITHOUT permission checks)

M AddNewObjectsAsync<TProps>(IEnumerable<IRedbObject<TProps>>) 🚀 BULK INSERT: Create multiple new objects in one operation (WITHOUT permission checks)

M AssignMissingIds(List<IRedbObject>, IRedbUser) 🎯 STEP 3: Assigning ID via GetNextKey() to all objects without ID

M CollectAllObjectsRecursively(IRedbObject, List<IRedbObject>, HashSet<long>) 🔍 STEP 2: Recursive collection of all IRedbObject (main + nested)

M ConvertToObjectRecord(IRedbObject) Convert IRedbObject to RedbObjectRow for bulk operations

M DeleteAsync(IEnumerable<IRedbObject>, IRedbUser) Bulk deletion of objects by interface with explicit user

M DeleteAsync(IEnumerable<IRedbObject>) Bulk deletion of objects by interface (uses _securityContext)

M DeleteAsync(IRedbObject, IRedbUser) Deletes an object from the database using atomic ExecuteDeleteAsync.

M DeleteAsync(IRedbObject) Delete object (uses _securityContext and config.DefaultCheckPermissionsOnDelete).

M EnsureSchemesForAllTypes(List<IRedbObject>) 🏗️ STEP 4: Creating/verifying schemas for all object types (using PostgresSchemeSyncProvider)

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

M LoadAsync<TProps>(IRedbObject, int, bool?) Load object from EAV (uses _securityContext and config.DefaultCheckPermissionsOnLoad)

M LoadAsync<TProps>(IRedbObject, IRedbUser, int, bool?) Load object from EAV with explicitly specified user (uses config.DefaultCheckPermissionsOnLoad)

M LoadWithParentsAsync<TProps>(IRedbObject, int, bool?) Load object with parent chain to root (uses _securityContext).

M LoadWithParentsAsync<TProps>(IRedbObject, IRedbUser, int, bool?) Load object by ID with parent chain to root with explicit user.

T ObjectStorageProviderBase(IRedbContext, IRedbObjectSerializer, IPermissionProvider, IRedbSecurityContext, ISchemeSyncProvider, RedbServiceConfiguration, ISqlDialect, IListProvider?, ILogger?) Creates a new ObjectStorageProviderBase instance.

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 SaveAsync(IEnumerable<IRedbObject>, IRedbUser) 🚀 BATCH SAVE with explicit user

M SaveAsync(IEnumerable<IRedbObject>) 🚀 BATCH SAVE: Save multiple objects (new + updates)

M SaveAsync(IRedbObject, IRedbUser) Save single object via interface with explicit user.

M SaveAsync(IRedbObject) Save single object via interface. Type determined internally.

M SaveAsync<TProps>(IRedbObject<TProps>, IRedbUser) Save generic object to EAV with explicit user (uses config.DefaultCheckPermissionsOnSave).

M SaveAsync<TProps>(IRedbObject<TProps>) Save generic object to EAV (uses _securityContext and config.DefaultCheckPermissionsOnSave).

M SaveAsyncNew<TProps>(IRedbObject<TProps>, IRedbUser) 🚀 NEW SAVEASYNC: Correct recursive processing of all data types

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

M SoftDeleteAsync(IEnumerable<IRedbObject>, IRedbUser, long?) Mark objects for soft-deletion with explicit user.

M SoftDeleteAsync(IEnumerable<IRedbObject>, long?) Mark objects for soft-deletion (uses _securityContext).

C OrderingExpressionParser redb.Core.Query

M ParseRedbOrdering<TKey>(Expression<Func<IRedbObject, TKey>>, SortDirection) Parse sorting by base IRedbObject fields (id, name, date_create, etc.)

C PermissionProviderBase redb.Core.Providers.Base