Interface IRedbConnection
Database connection abstraction for REDB.
Replaces DbContext with pure ADO.NET approach.
All methods automatically use CurrentTransaction if active.
public interface IRedbConnection : IAsyncDisposable, IDisposable
Properties
CurrentTransaction
Currently active transaction (null if no transaction).
IRedbTransaction? CurrentTransaction { get; }
IsDisposed
True once the connection has been disposed - its scope has ended (V4, review).
bool IsDisposed { get; }
IsInTransaction
Whether any transaction is active — explicit (CurrentTransaction) or ambient (TransactionScope).
bool IsInTransaction { get; }
Methods
BeginTransactionAsync(IsolationLevel?, CancellationToken)
Begin new transaction.
Task<IRedbTransaction> BeginTransactionAsync(IsolationLevel? isolationLevel = null, CancellationToken cancellationToken = default)
Execute(string, params object[])
Synchronous : runs on the calling thread down to ADO.NET.
int Execute(string sql, params object[] parameters)
ExecuteAsync(string, object[], CancellationToken)
Cancellable form.
Task<int> ExecuteAsync(string sql, object[] parameters, CancellationToken cancellationToken)
ExecuteAsync(string, params object[])
Execute SQL command (INSERT, UPDATE, DELETE) and return affected rows count.
Task<int> ExecuteAsync(string sql, params object[] parameters)
ExecuteAtomicAsync(Func<Task>, CancellationToken)
Execute multiple operations atomically (all-or-nothing).
Task ExecuteAtomicAsync(Func<Task> operations, CancellationToken cancellationToken = default)
ExecuteAtomicAsync(Func<Task>)
Execute multiple operations atomically (all-or-nothing).
Task ExecuteAtomicAsync(Func<Task> operations)
ExecuteAtomicAsync(IsolationLevel, Func<Task>, CancellationToken)
Atomic execution under an explicit isolation level (BR-1). An active or ambient transaction
Task ExecuteAtomicAsync(IsolationLevel isolationLevel, Func<Task> operations, CancellationToken cancellationToken = default)
ExecuteAtomicAsync<T>(Func<Task<T>>, CancellationToken)
Execute multiple operations atomically and return result.
Task<T> ExecuteAtomicAsync<T>(Func<Task<T>> operations, CancellationToken cancellationToken = default)
ExecuteAtomicAsync<T>(Func<Task<T>>)
Execute multiple operations atomically and return result.
Task<T> ExecuteAtomicAsync<T>(Func<Task<T>> operations)
ExecuteAtomicAsync<T>(IsolationLevel, Func<Task<T>>, CancellationToken)
Result-returning form of the isolation-level overload (BR-1).
Task<T> ExecuteAtomicAsync<T>(IsolationLevel isolationLevel, Func<Task<T>> operations, CancellationToken cancellationToken = default)
ExecuteJson(string, params object[])
Synchronous : runs on the calling thread down to ADO.NET.
string? ExecuteJson(string sql, params object[] parameters)
ExecuteJsonAsync(string, object[], CancellationToken)
Cancellable form.
Task<string?> ExecuteJsonAsync(string sql, object[] parameters, CancellationToken cancellationToken)
ExecuteJsonAsync(string, params object[])
Execute raw SQL function returning JSON.
Task<string?> ExecuteJsonAsync(string sql, params object[] parameters)
ExecuteJsonListAsync(string, object[], CancellationToken)
Cancellable form.
Task<List<string>> ExecuteJsonListAsync(string sql, object[] parameters, CancellationToken cancellationToken)
ExecuteJsonListAsync(string, params object[])
Execute raw SQL function returning multiple JSON rows.
Task<List<string>> ExecuteJsonListAsync(string sql, params object[] parameters)
ExecuteScalar<T>(string, params object[])
Synchronous : runs on the calling thread down to ADO.NET.
T? ExecuteScalar<T>(string sql, params object[] parameters)
ExecuteScalarAsync<T>(string, object[], CancellationToken)
Cancellable form.
Task<T?> ExecuteScalarAsync<T>(string sql, object[] parameters, CancellationToken cancellationToken)
ExecuteScalarAsync<T>(string, params object[])
Execute SQL query and return scalar value.
Task<T?> ExecuteScalarAsync<T>(string sql, params object[] parameters)
GetUnderlyingConnectionAsync()
Get underlying DbConnection for advanced operations (e.g., COPY protocol).
Task<DbConnection> GetUnderlyingConnectionAsync()
GetUnderlyingConnectionAsync(CancellationToken)
Get underlying DbConnection for advanced operations (e.g., COPY protocol).
Task<DbConnection> GetUnderlyingConnectionAsync(CancellationToken cancellationToken = default)
Query<T>(string, params object[])
Synchronous : runs on the calling thread down to ADO.NET.
List<T> Query<T>(string sql, params object[] parameters) where T : new()
QueryAsync<T>(string, object[], CancellationToken)
Cancellable form: parameters as an explicit array (params cannot precede ct).
Task<List<T>> QueryAsync<T>(string sql, object[] parameters, CancellationToken cancellationToken) where T : new()
QueryAsync<T>(string, params object[])
Execute SQL query and return list of mapped objects.
Task<List<T>> QueryAsync<T>(string sql, params object[] parameters) where T : new()
QueryFirstOrDefault<T>(string, params object[])
Synchronous : runs on the calling thread down to ADO.NET.
T? QueryFirstOrDefault<T>(string sql, params object[] parameters) where T : class, new()
QueryFirstOrDefaultAsync<T>(string, object[], CancellationToken)
Cancellable form.
Task<T?> QueryFirstOrDefaultAsync<T>(string sql, object[] parameters, CancellationToken cancellationToken) where T : class, new()
QueryFirstOrDefaultAsync<T>(string, params object[])
Execute SQL query and return first result or null.
Task<T?> QueryFirstOrDefaultAsync<T>(string sql, params object[] parameters) where T : class, new()
QueryScalarListAsync<T>(string, object[], CancellationToken)
Cancellable form.
Task<List<T>> QueryScalarListAsync<T>(string sql, object[] parameters, CancellationToken cancellationToken)
QueryScalarListAsync<T>(string, params object[])
Execute SQL query and return list of scalar values (first column only).
Task<List<T>> QueryScalarListAsync<T>(string sql, params object[] parameters)