private static async Task <List <dynamic> > GetRows(
string query,
Func <QC.SqlDataReader, dynamic> rowConverter)
{
var result = new List <dynamic>();
var connectionString = Environment.GetEnvironmentVariable("GIFTS_DB_ADO_NET_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 = query;
QC.SqlDataReader reader = await command.ExecuteReaderAsync();
while (reader.Read())
{
result.Add(rowConverter(reader));
}
}
}
return(result);
}
public static async Task <MicrosoftData.SqlConnection> CreateMicrosoftDataSqlConnectionAsync()
{
var sqlConnection = new MicrosoftData.SqlConnection(TestConfiguration.SqlConnectionString);
await sqlConnection.OpenAsync();
return(sqlConnection);
}
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());
}
}
}
