public async Task <int> ExecuteNonQueryStoredProcedureAsync(string name, params ParameterDefinition[] parameterDefinitions)
{
LogExecuteProc(name);
ISqlConnection connection = connectionProvider.Provide <ISqlConnection>();
await connection.OpenAsync();
int num1;
using (ISqlCommand command = connection.CreateCommand(null))
{
command.CommandTimeout = 300000;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = name;
ParameterDefinition[] parameterDefinitionArray = parameterDefinitions;
for (int index = 0; index < parameterDefinitionArray.Length; ++index)
{
ParameterDefinition parameterDefinition = parameterDefinitionArray[index];
command.Parameters.AddWithValue(parameterDefinition.Name, parameterDefinition.Value, parameterDefinition.IsNullable, parameterDefinition.DbType, parameterDefinition.Size, parameterDefinition.Direction);
parameterDefinition = null;
}
parameterDefinitionArray = null;
int num = await command.ExecuteNonQueryAsync();
int result = num;
GetParameterCollection(command.Parameters.GetParameter(), parameterDefinitions);
num1 = result;
}
return(num1);
}
public async Task <int> ExecuteNonQueryAsync(string sql)
{
LogQuery(sql);
ISqlConnection connection = connectionProvider.Provide <ISqlConnection>();
await connection.OpenAsync();
int num1;
using (ISqlCommand command = connection.CreateCommand(connectionProvider.GetDbTransaction))
{
command.CommandTimeout = 300000;
command.CommandType = CommandType.Text;
command.CommandText = sql;
int num = await command.ExecuteNonQueryAsync();
num1 = num;
}
return(num1);
}
