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