/// <summary>
/// Execute a query asynchronously using .NET 4.5 Task.
/// </summary>
/// <typeparam name="T">The type of results to return.</typeparam>
/// <typeparam name="TConn"></typeparam>
/// <param name="cnn">The connection to query on.</param>
/// <param name="sql">The SQL to execute for the query.</param>
/// <param name="param">The parameters to pass, if any.</param>
/// <param name="transaction">The transaction to use, if any.</param>
/// <param name="commandTimeout">The command timeout (in seconds).</param>
/// <param name="commandType">The type of command to execute.</param>
/// <param name="cancellationToken"></param>
/// <returns>
/// A sequence of data of <typeparamref name="T"/>; if a basic type (int, string, etc) is queried then the data from the first column in assumed, otherwise an instance is
/// created per row, and a direct column-name===member-name mapping is assumed (case insensitive).
/// </returns>
public static async Task <IEnumerable <T> > SaveAsync <T, TConn>(this IDataConnection <TConn> cnn, string sql, object param = null, IDbTransaction transaction = null, int?commandTimeout = null, CommandType?commandType = null, CancellationToken cancellationToken = default) where TConn : IDbConnection
{
var timeout = commandTimeout ?? 30;
var connection = await cnn.GetOpenConnectionAsync(cancellationToken).ConfigureAwait(false);
var retryPolicy = cnn.RetryPolicy?.GetStandardSaveQueryRetryPolicy();
transaction = transaction ?? cnn.CurrentTransaction;
return(await QueryAsync <T>(connection, sql, param, transaction, timeout, commandType, retryPolicy,
cancellationToken).ConfigureAwait(false));
}
/// <summary>
/// Execute a single-row query asynchronously using .NET 4.5 Task.
/// </summary>
/// <typeparam name="TFirst">The first type in the record set.</typeparam>
/// <typeparam name="TSecond">The second type in the record set.</typeparam>
/// <typeparam name="TConn"></typeparam>
/// <typeparam name="TReturn">The combined type to return.</typeparam>
/// <param name="cnn">The connection to query on.</param>
/// <param name="sql">The SQL to execute for the query.</param>
/// <param name="map">The function to map row types to the return type.</param>
/// <param name="param">The parameters to pass, if any.</param>
/// <param name="transaction">The transaction to use, if any.</param>
/// <param name="commandTimeout">The command timeout (in seconds).</param>
/// <param name="commandType">The type of command to execute.</param>
/// <param name="splitOn">The field we should split and read the second object from (default: "Id").</param>
/// <param name="cancellationToken"></param>
/// <returns></returns>
public static async Task <TReturn> SaveFirstOrDefaultAsync <TFirst, TSecond, TConn, TReturn>(this IDataConnection <TConn> cnn,
string sql, Func <TFirst, TSecond, TReturn> map, object param = null, IDbTransaction transaction = null, int?commandTimeout = null, CommandType?commandType = null, string splitOn = "Id", CancellationToken cancellationToken = default) where TConn : DbConnection
{
var timeout = commandTimeout ?? cnn.DefaultCommandTimeout;
var connection = await cnn.GetOpenConnectionAsync(cancellationToken).ConfigureAwait(false);
var retryPolicy = cnn.RetryPolicy?.GetStandardSaveQueryRetryPolicy();
transaction = transaction ?? cnn.CurrentTransaction;
var items = await QueryAsync(connection, sql, map, param, transaction, timeout, commandType, retryPolicy, splitOn,
cancellationToken).ConfigureAwait(false);
return(items.FirstOrDefault());
}
