private static void PrintScriptMultipleResult(ScriptMultipleResult result)
{
if (!result.IsSuccess)
{
Console.WriteLine("ERRORS: ");
foreach (var error in result.Errors)
{
Console.WriteLine(error);
}
}
else
{
foreach (var dataSet in result.Data)
{
Console.WriteLine();
foreach (var row in dataSet)
{
Console.WriteLine(row);
}
}
}
}
public async Task <ScriptMultipleResult> ExecuteScriptMultiple(string script, object param = null)
{
var result = new ScriptMultipleResult();
var data = new List <IEnumerable <dynamic> >();
try {
using (var connection = BuildConnection()) {
var reader = await connection.QueryMultipleAsync(script, param);
while (!reader.IsConsumed)
{
data.Add(reader.Read());
}
result.Data = data;
}
}
catch (SqlException e) {
result.SetException(e);
}
return(result);
}
