Class SqlRedbConnection

Namespace: redb.MSSql.Data
Assembly: redb.MSSql.dll

MS SQL Server implementation of IRedbConnection using Microsoft.Data.SqlClient.
Provides pure ADO.NET database access with automatic transaction management.

public class SqlRedbConnection : IRedbConnection, IAsyncDisposable, IDisposable

Inheritance

Object→SqlRedbConnection

Implements

Properties

ConnectionString

Connection string.

public string ConnectionString { get; }

CurrentTransaction

Current active transaction.

public IRedbTransaction? CurrentTransaction { get; }

IsDisposed

True once the connection has been disposed - its scope has ended (V4, review).

public bool IsDisposed { get; }

IsInTransaction

Whether any transaction is active — explicit or ambient TransactionScope.

public bool IsInTransaction { get; }

Methods

BeginTransactionAsync()

Begin new transaction.

public Task<IRedbTransaction> BeginTransactionAsync()

BeginTransactionAsync(IsolationLevel?, CancellationToken)

Begin new transaction.

public Task<IRedbTransaction> BeginTransactionAsync(IsolationLevel? isolationLevel = null, CancellationToken cancellationToken = default)

Dispose()

Synchronous dispose for DI container compatibility.

public void Dispose()

DisposeAsync()

Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources asynchronously.

public ValueTask DisposeAsync()

Execute(string, params object[])

Synchronous : runs on the calling thread down to ADO.NET.

public int Execute(string sql, params object[] parameters)

ExecuteAsync(string, object[], CancellationToken)

Cancellable form.

public Task<int> ExecuteAsync(string sql, object[] parameters, CancellationToken cancellationToken)

ExecuteAsync(string, params object[])

Execute SQL command (INSERT, UPDATE, DELETE).

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

ExecuteAtomicAsync(Func<Task>, CancellationToken)

Execute operations atomically (SaveChanges replacement).

public Task ExecuteAtomicAsync(Func<Task> operations, CancellationToken cancellationToken = default)

ExecuteAtomicAsync(Func<Task>)

Execute operations atomically (SaveChanges replacement).

public Task ExecuteAtomicAsync(Func<Task> operations)

ExecuteAtomicAsync(IsolationLevel, Func<Task>, CancellationToken)

Atomic execution under an explicit isolation level (BR-1). An active or ambient transaction

public Task ExecuteAtomicAsync(IsolationLevel isolationLevel, Func<Task> operations, CancellationToken cancellationToken = default)

ExecuteAtomicAsync<T>(Func<Task<T>>, CancellationToken)

Execute operations atomically and return result.

public Task<T> ExecuteAtomicAsync<T>(Func<Task<T>> operations, CancellationToken cancellationToken = default)

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

Execute operations atomically and return result.

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

public 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.

public string? ExecuteJson(string sql, params object[] parameters)

ExecuteJsonAsync(string, object[], CancellationToken)

Cancellable form.

public Task<string?> ExecuteJsonAsync(string sql, object[] parameters, CancellationToken cancellationToken)

ExecuteJsonAsync(string, params object[])

Execute SQL returning JSON (for MSSQL functions returning JSON).

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

ExecuteJsonListAsync(string, object[], CancellationToken)

Cancellable form.

public Task<List<string>> ExecuteJsonListAsync(string sql, object[] parameters, CancellationToken cancellationToken)

ExecuteJsonListAsync(string, params object[])

Execute SQL returning multiple JSON rows.

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

ExecuteScalar<T>(string, params object[])

Synchronous : runs on the calling thread down to ADO.NET.

public T? ExecuteScalar<T>(string sql, params object[] parameters)

ExecuteScalarAsync<T>(string, object[], CancellationToken)

Cancellable form.

public Task<T?> ExecuteScalarAsync<T>(string sql, object[] parameters, CancellationToken cancellationToken)

ExecuteScalarAsync<T>(string, params object[])

Execute SQL query and return scalar value.

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

GetUnderlyingConnectionAsync()

Get underlying connection (for bulk operations).

public Task<DbConnection> GetUnderlyingConnectionAsync()

GetUnderlyingConnectionAsync(CancellationToken)

Get underlying connection (for bulk operations).

public Task<DbConnection> GetUnderlyingConnectionAsync(CancellationToken cancellationToken = default)

Query<T>(string, params object[])

Synchronous : runs on the calling thread down to ADO.NET.

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

public 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.

public 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.

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

QueryFirstOrDefaultAsync<T>(string, object[], CancellationToken)

Cancellable form.

public 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.

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

QueryRowsAsJsonAsync(string, object[], CancellationToken)

Execute SQL and serialize the result rows to a JSON array string in C# (column names from the reader),

public Task<string> QueryRowsAsJsonAsync(string sql, object[] parameters, CancellationToken cancellationToken)

QueryScalarListAsync<T>(string, object[], CancellationToken)

Cancellable form.

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

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

Constructors

SqlRedbConnection(string, bool)

Create connection from connection string.

SqlRedbConnection(string)

Create connection from connection string.