protected async Task <int> ExecuteRawSql(
string rawSql, object param = null)
{
return(await SqlRawHelper.ExecuteSqlAsync(
db.Database.GetDbConnection(),
rawSql,
param
));
}
protected async Task <IEnumerable <T> > RawSqlReaderAsync <T>(
string rawSql,
object param,
Func <DbDataReader, T> converter)
{
return(await SqlRawHelper.ExecuteReaderAsync(
db.Database.GetDbConnection(),
rawSql,
converter,
param
));
}
protected async Task <T> RawSqlResultAsync <T>(
string rawSql,
object param = null)
{
var results = await SqlRawHelper.ExecuteReaderAsync(
db.Database.GetDbConnection(),
rawSql,
r => (T)Convert.ChangeType(r[0], typeof(T)),
param
);
return(results.FirstOrDefault());
}
public async Task SetupDatabaseAsync()
{
using (var tx = await Connection.BeginTransactionAsync())
{
var tables = TestCaseExcel.Database.ToArray();
await Task.WhenAll(
tables.Reverse().Select(m
=> SqlRawHelper.ExecuteSqlAsync(Connection, $"delete from {m.TableName}"))
);
await Task.WhenAll(
tables.Select(table =>
SqlRawHelper.ImportDataTableAsync(Connection, table)));
await tx.CommitAsync();
}
}
