Class SqlRedbConnection
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
Implements
Properties
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(IsolationLevel?, CancellationToken)
Begin new transaction.
public Task<IRedbTransaction> BeginTransactionAsync(IsolationLevel? isolationLevel = null, CancellationToken cancellationToken = default)
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.