Interface IRedbConnection

Namespace: redb.Core.Data
Assembly: redb.Core.dll

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

ConnectionString

Connection string used for this connection.

string ConnectionString { get; }

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

Begin new transaction.

Task<IRedbTransaction> BeginTransactionAsync()

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)