/// <inheritdoc />
public Task <IEnumerable <T> > ExecuteStoredProcedureAsync <T>(
ICuriosityReadOnlyDataContext context,
string procedureName,
IDictionary <string, object>?parameters = null,
int?commandTimeoutSec = null,
bool ignoreNulls = true,
CancellationToken cancellationToken = default)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
var connection = context.Connection;
var dynamicParams = parameters?.ConvertToDynamicParameters(ignoreNulls);
var commandDefinition = new CommandDefinition(
procedureName,
dynamicParams,
commandTimeout: commandTimeoutSec,
commandType: CommandType.StoredProcedure,
cancellationToken: cancellationToken);
return(connection.QueryAsync <T>(commandDefinition));
}
/// <inheritdoc />
public T QuerySingleOrDefault <T>(
ICuriosityReadOnlyDataContext context,
string sqlTemplate,
IDictionary <string, object>?parameters = null,
bool ignoreNulls = false,
int?commandTimeoutSec = null)
{
var dynamicParams = parameters?.ConvertToDynamicParameters(ignoreNulls);
var connection = context.Connection;
return(connection.QuerySingleOrDefault <T>(sqlTemplate, dynamicParams, commandTimeout: commandTimeoutSec));
}
/// <inheritdoc />
public Task <IEnumerable <T> > QueryManyAsync <T>(
ICuriosityReadOnlyDataContext context,
string sqlTemplate,
object?parameters,
int?commandTimeoutSec = null,
CancellationToken cancellationToken = default)
{
var connection = context.Connection;
var commandDefinition = new CommandDefinition(sqlTemplate, parameters, commandTimeout: commandTimeoutSec, cancellationToken: cancellationToken);
return(connection.QueryAsync <T>(commandDefinition));
}
/// <inheritdoc />
public IEnumerable <T> QueryMany <T>(
ICuriosityReadOnlyDataContext context,
string sqlTemplate,
IDictionary <string, object>?parameters = null,
bool ignoreNulls = false,
int?commandTimeoutSec = null)
{
var dynamicParams = parameters?.ConvertToDynamicParameters(ignoreNulls);
var connection = context.Connection;
var result = connection.Query <T>(sqlTemplate, dynamicParams, commandTimeout: commandTimeoutSec);
return(result);
}
/// <inheritdoc />
public Task <IEnumerable <T> > QueryManyAsync <T>(
ICuriosityReadOnlyDataContext context,
string sqlTemplate,
IDictionary <string, object>?parameters = null,
bool ignoreNulls = true,
int?commandTimeoutSec = null,
CancellationToken cancellationToken = default)
{
var dynamicParams = parameters?.ConvertToDynamicParameters(ignoreNulls);
var commandDefinition = new CommandDefinition(sqlTemplate, dynamicParams, commandTimeout: commandTimeoutSec, cancellationToken: cancellationToken);
var connection = context.Connection;
return(connection.QueryAsync <T>(commandDefinition));
}
/// <inheritdoc />
public IEnumerable <T> ExecuteStoredProcedure <T>(
ICuriosityReadOnlyDataContext context,
string procedureName,
IDictionary <string, object>?parameters = null,
int?commandTimeoutSec = null,
bool ignoreNulls = true)
{
if (context == null)
{
throw new ArgumentNullException(nameof(context));
}
var connection = context.Connection;
var dynamicParams = parameters?.ConvertToDynamicParameters(ignoreNulls);
return(connection.Query <T>(
procedureName,
dynamicParams,
commandTimeout: commandTimeoutSec,
commandType: CommandType.StoredProcedure));
}