Interface IRedbContext

Assembly: redb.Core.dll

Main database context interface for REDB.
Facade over connection, key generator, and bulk operations.
Replaces EF Core DbContext.

public interface IRedbContext : IAsyncDisposable, IDisposable

Properties

Bulk operations (COPY protocol).

IBulkOperations Bulk { get; }

Current active transaction (null if none).

IRedbTransaction? CurrentTransaction { get; }

Database connection for queries and commands.

IRedbConnection Db { get; }

Key generator with caching.

IKeyGenerator Keys { get; }

Begin new transaction.

Task<IRedbTransaction> BeginTransactionAsync()

Execute SQL command (INSERT, UPDATE, DELETE).

Task<int> ExecuteAsync(string sql, params object[] parameters)

Execute operations atomically (all-or-nothing).

Task ExecuteAtomicAsync(Func<Task> operations)

Execute operations atomically and return result.

Task<T> ExecuteAtomicAsync<T>(Func<Task<T>> operations)

Execute SQL returning JSON.

Task<string?> ExecuteJsonAsync(string sql, params object[] parameters)

Execute SQL returning multiple JSON rows.

Task<List<string>> ExecuteJsonListAsync(string sql, params object[] parameters)

Execute SQL query and return scalar value.

Task<T?> ExecuteScalarAsync<T>(string sql, params object[] parameters)

Get next object ID.

Task<long> NextObjectIdAsync()

Get batch of object IDs.

Task<long[]> NextObjectIdBatchAsync(int count)

Get next value ID.

Task<long> NextValueIdAsync()

Get batch of value IDs.

Task<long[]> NextValueIdBatchAsync(int count)

Execute SQL query and return list of mapped objects.

Task<List<T>> QueryAsync<T>(string sql, params object[] parameters) where T : new()

Execute SQL query and return first result or null.

Task<T?> QueryFirstOrDefaultAsync<T>(string sql, params object[] parameters) where T : class, new()

Execute SQL query and return list of scalar values (first column only).

Task<List<T>> QueryScalarListAsync<T>(string sql, params object[] parameters)