<PackageReference Include="Relativity.Server.Utility.SDK" Version="14.2.7" />

IAsyncContext

public interface IAsyncContext
Represents an asynchronous connection to a database.
string Database { get; }

Gets the database name used by this IAsyncContext.

bool IsMasterDatabase { get; }

Indicates whether or not this IAsyncContext is connected to a master database.

string ServerName { get; }

Gets the server name used by this IAsyncContext.

Task BeginTransactionAsync()

Asynchronously begins a transaction.

Task BeginTransactionAsync(CancellationToken cancelToken)

Asynchronously begins a transaction.

IAsyncContext Clone()

Clones this IAsyncContext, returning a new IAsyncContext.

void CommitTransaction()

Commits the currently open transaction.

Task ExecuteBulkCopyAsync(IDataReader dataReader, SqlBulkCopyParameters bulkCopyParameters, CancellationToken cancelToken)

Asynchronously executes a bulk copy job from an IDataReader source, using the provided parameters and cancellation token.

Task ExecuteBulkCopyAsync(DataTable dataTable, SqlBulkCopyParameters bulkCopyParameters, CancellationToken cancelToken)

Asynchronously executes a bulk copy job from a DataTable source, using the provided parameters and cancellation token.

Task<int> ExecuteNonQueryAsync(QueryInformation query)

Asynchronously executes the provided QueryInformation

Expects to represent a create, update, or delete query.

Task<DataTable> ExecuteQueryAsDataTableAsync(QueryInformation query)

Asynchronously executes the provided QueryInformation.

Expects to represent a read or query query.

Task<List<T>> ExecuteQueryAsListAsync<T>(QueryInformation query, Func<IDataReader, Task<T>> converter)

Asynchronously executes the provided QueryInformation, using the provided converter function.

Task<List<T>> ExecuteQueryAsListAsync<T>(QueryInformation query, Func<IDataReader, CancellationToken, Task<T>> converter)

Asynchronously executes the provided QueryInformation, using the provided converter function.

Task<T> ExecuteQueryAsObjectAsync<T>(QueryInformation query, Func<IDataReader, Task<T>> converter)

Asynchronously executes the provided QueryInformation, using the provided converter function.

Task<T> ExecuteQueryAsObjectAsync<T>(QueryInformation query, Func<IDataReader, CancellationToken, Task<T>> converter)

Asynchronously executes the provided QueryInformation, using the provided converter function.

Task<T> ExecuteQueryAsScalarAsync<T>(QueryInformation query)

Asynchronously executes the provided QueryInformation. Expects to return exactly one result that can be casted to type T.

Task<SqlConnection> GetConnectionAsync()

Asynchronously gets the underlying database connection of this IAsyncContext.

Task<SqlConnection> GetConnectionAsync(CancellationToken cancellationToken)

Asynchronously gets the underlying database connection of this IAsyncContext.

SqlTransaction GetTransaction()

Gets the current transaction being managed.

void ReleaseConnection()

Releases the connection to the database.

void RollbackTransaction()

Rolls back the currently open transaction.