public static async Task TruncateTransactionalOutboxTableAsync(this MicrosoftData.SqlConnection sqlConnection) { //CLEAR the Table for Integration Tests to validate: await using var sqlCmd = new MicrosoftData.SqlCommand( SqlCommands.TruncateTransactionalOutbox, sqlConnection ); await sqlCmd.ExecuteNonQueryAsync().ConfigureAwait(false); }
private static async Task <int> ExecuteUpdate(string update, Dictionary <string, object> parameters) { var connectionString = Environment.GetEnvironmentVariable("GIFTS_DB_CONNECTION_STRING"); using (var connection = new QC.SqlConnection(connectionString)) { await connection.OpenAsync(); using (var command = new QC.SqlCommand()) { command.Connection = connection; command.CommandType = DT.CommandType.Text; command.CommandText = update; foreach (var item in parameters) { command.Parameters.AddWithValue(item.Key, item.Value); } return(await command.ExecuteNonQueryAsync()); } } }