public static async Task <DataTableResults> ReadProductsTask(CancellationToken ct)
{
var result = new DataTableResults()
{
DataTable = new DataTable()
};
_connectionString = RunWithoutIssues ?
"Data Source=.\\sqlexpressISSUE;Initial Catalog=NorthWind2020;Integrated Security=True" :
"Data Source=.\\sqlexpress;Initial Catalog=NorthWind2020;Integrated Security=True";
return(await Task.Run(async() =>
{
using (var cn = new SqlConnection(_connectionString))
{
using (var cmd = new SqlCommand()
{
Connection = cn
})
{
cmd.CommandText = SelectStatement();
try
{
await cn.OpenAsync(ct);
}
catch (TaskCanceledException tce)
{
Exceptions.Write(tce, ExceptionLogType.ConnectionFailure,
$"Connection string '{_connectionString}'");
result.ConnectionFailed = true;
result.ExceptionMessage = "Connection Failed";
return result;
}
catch (Exception ex)
{
Exceptions.Write(ex, ExceptionLogType.General);
result.GeneralException = ex;
return result;
}
result.DataTable.Load(await cmd.ExecuteReaderAsync(ct));
}
}
return result;
}));
}
public static async Task <DataTableResults> ReadProductsTask(CancellationToken ct)
{
var result = new DataTableResults()
{
DataTable = new DataTable()
};
return(await Task.Run(async() =>
{
using (var cn = new SqlConnection(_connectionString))
{
using (var cmd = new SqlCommand()
{
Connection = cn
})
{
cmd.CommandText = SelectStatement();
try
{
await cn.OpenAsync(ct);
}
catch (TaskCanceledException tce)
{
Exceptions.Write(tce, ExceptionLogType.ConnectionFailure, $"Connection string '{_connectionString}'");
result.ConnectionFailed = true;
result.ExceptionMessage = "Connection Failed";
return result;
}
catch (Exception ex)
{
Exceptions.Write(ex, ExceptionLogType.General);
result.GeneralException = ex;
return result;
}
result.DataTable.Load(await cmd.ExecuteReaderAsync());
}
}
return result;
}));
}
