async Task <string> PerformAndRollback(IEnumerable <string> setupQueries, string selectQuery)
{
try
{
var result = await Task.Run(() => _executor.ExecuteWithRollback(
setupQueries, new List <string> {
selectQuery
}));
return(string.Concat(result.Single().Select(r => r.Data)));
}
catch (Exception ex)
{
return("Error in query: " + ex.Message);
}
}
public async Task <string> TestTableSetup(string setup)
{
try
{
if (string.IsNullOrEmpty(setup))
{
throw new Exception("Query cannot be empty");
}
await Task.Run(() => _executor.ExecuteWithRollback(new List <string>
{
setup
}, null));
}
catch (Exception ex)
{
return("ERROR: " + ex.Message);
}
return(string.Empty);
}
