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