Class SqlDataRequestResolver
SQL Server implementation of IDataRequestResolver<TConnection>. Creates, opens, and disposes a SqlConnection per call.
public sealed class SqlDataRequestResolver : IDataRequestResolver<SqlConnection>
- Inheritance
-
SqlDataRequestResolver
- Implements
- Inherited Members
Constructors
SqlDataRequestResolver(Func<SqlConnection>)
Initializes a new instance of the SqlDataRequestResolver class using a connection factory.
public SqlDataRequestResolver(Func<SqlConnection> connectionFactory)
Parameters
connectionFactoryFunc<SqlConnection>A factory that produces SqlConnection instances.
Exceptions
- ArgumentNullException
Thrown when
connectionFactoryis null.
SqlDataRequestResolver(string)
Initializes a new instance of the SqlDataRequestResolver class using a connection string.
public SqlDataRequestResolver(string connectionString)
Parameters
connectionStringstringThe SQL Server connection string.
Exceptions
- ArgumentException
Thrown when
connectionStringis null or whitespace.
Methods
ExecuteAsync(IDataRequest<SqlConnection, int>, CancellationToken)
Executes a data request that performs a side effect without returning a meaningful result.
public Task ExecuteAsync(IDataRequest<SqlConnection, int> request, CancellationToken cancellationToken)
Parameters
requestIDataRequest<SqlConnection, int>The data request to execute.
cancellationTokenCancellationTokenThe cancellation token.
Returns
- Task
A task representing the asynchronous operation.
QueryAsync<TModel>(IDataRequest<SqlConnection, TModel>, CancellationToken)
Executes a data request that returns a result.
public Task<TModel> QueryAsync<TModel>(IDataRequest<SqlConnection, TModel> request, CancellationToken cancellationToken)
Parameters
requestIDataRequest<SqlConnection, TModel>The data request to execute.
cancellationTokenCancellationTokenThe cancellation token.
Returns
- Task<TModel>
The result of the data request execution.
Type Parameters
TModelThe type of the result model.