Interface IAsyncDbConnection

Namespace

LinqToDB.Async

Assembly

linq2db.dll

Wrapper over DbConnection instance which contains all operations that could have custom implementation like:

• IRetryPolicy support
• asynchronous operations, missing from DbConnection but provided by data provider implementation.

public interface IAsyncDbConnection : IDisposable, IAsyncDisposable

Inherited Members

IDisposable.Dispose()

IAsyncDisposable.DisposeAsync()

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Properties

Connection

Gets underlying connection instance.

DbConnection Connection { get; }

Property Value

DbConnection

ConnectionString

string ConnectionString { get; set; }

Property Value

string

State

ConnectionState State { get; }

Property Value

ConnectionState

Methods

BeginTransaction()

Starts new transaction for current connection with default isolation level.

IAsyncDbTransaction BeginTransaction()

Returns

IAsyncDbTransaction

Database transaction object.

BeginTransaction(IsolationLevel)

Starts new transaction for current connection with specified isolation level.

IAsyncDbTransaction BeginTransaction(IsolationLevel isolationLevel)

Parameters

isolationLevel IsolationLevel

Transaction isolation level.

Returns

IAsyncDbTransaction

Database transaction object.

BeginTransactionAsync(IsolationLevel, CancellationToken)

Starts new transaction asynchronously for current connection with specified isolation level.

ValueTask<IAsyncDbTransaction> BeginTransactionAsync(IsolationLevel isolationLevel, CancellationToken cancellationToken)

Parameters

isolationLevel IsolationLevel

Transaction isolation level.

cancellationToken CancellationToken

Asynchronous operation cancellation token.

Returns

ValueTask<IAsyncDbTransaction>

Database transaction object.

BeginTransactionAsync(CancellationToken)

Starts new transaction asynchronously for current connection with default isolation level.

ValueTask<IAsyncDbTransaction> BeginTransactionAsync(CancellationToken cancellationToken)

Parameters

cancellationToken CancellationToken

Asynchronous operation cancellation token.

Returns

ValueTask<IAsyncDbTransaction>

Database transaction object.

Close()

void Close()

CloseAsync()

Closes current connection asynchonously.

Task CloseAsync()

Returns

Task

Async operation task.

CreateCommand()

DbCommand CreateCommand()

Returns

DbCommand

Open()

void Open()

OpenAsync(CancellationToken)

Task OpenAsync(CancellationToken cancellationToken)

Parameters

cancellationToken CancellationToken

Returns

Task

TryClone()

Returns cloned connection instance, if underlying provider supports cloning or null otherwise.

DbConnection? TryClone()

Returns

DbConnection