/// <inheritdoc />
public void Execute(
ICuriosityDataContext context,
string sqlTemplate,
IDictionary <string, object>?parameters = null,
bool ignoreNulls = false,
int?commandTimeoutSec = null)
{
var dynamicParams = parameters?.ConvertToDynamicParameters(ignoreNulls);
var connection = context.Connection;
connection.Execute(sqlTemplate, dynamicParams, commandTimeout: commandTimeoutSec);
}
/// <inheritdoc />
public Task ExecuteAsync(
ICuriosityDataContext context,
string sqlTemplate,
IDictionary <string, object>?parameters = null,
bool ignoreNulls = false,
int?commandTimeoutSec = null,
CancellationToken cancellationToken = default)
{
var dynamicParams = parameters?.ConvertToDynamicParameters(ignoreNulls);
var command = new CommandDefinition(sqlTemplate, dynamicParams, commandTimeout: commandTimeoutSec, cancellationToken: cancellationToken);
var connection = context.Connection;
return(connection.ExecuteAsync(command));
}
/// <inheritdoc />
public void ExecuteStoredProcedure(
ICuriosityDataContext context,
string procedureName,
IDictionary <string, object>?parameters = null,
int?commandTimeoutSec = null,
bool ignoreNulls = true)
{
var connection = context.Connection;
var dynamicParams = parameters?.ConvertToDynamicParameters(ignoreNulls);
connection.QuerySingleOrDefault(
procedureName,
dynamicParams,
commandTimeout: commandTimeoutSec,
commandType: CommandType.StoredProcedure);
}
/// <inheritdoc />
public Task ExecuteStoredProcedureAsync(
ICuriosityDataContext context,
string procedureName,
IDictionary <string, object>?parameters = null,
int?commandTimeoutSec = null,
bool ignoreNulls = true,
CancellationToken cancellationToken = default)
{
var connection = context.Connection;
var dynamicParams = parameters?.ConvertToDynamicParameters(ignoreNulls);
var commandDefinition = new CommandDefinition(
procedureName,
dynamicParams,
commandTimeout: commandTimeoutSec,
commandType: CommandType.StoredProcedure,
cancellationToken: cancellationToken);
return(connection.QuerySingleOrDefaultAsync(commandDefinition));
}
