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());
}
}
}
