public async Task FillAsyncDataSet()
{
using (var conn = new SqlConnection())
{
conn.ConnectionString = ConnectionString;
await conn.OpenAsync();
using (var c = conn.CreateCommand())
{
c.CommandText = "GetFast";
c.CommandType = CommandType.StoredProcedure;
c.Parameters.Add("@Number", SqlDbType.Int).Value = 100000;
using (var a = new SqlDataAdapter(c))
{
var ds = new DataSet();
var r = await a.FillAsync(ds);
Assert.AreEqual(1, ds.Tables.Count);
var dt = ds.Tables[0];
Assert.AreEqual(900000, r);
Assert.AreEqual(900000, dt.Rows.Count);
AssertDataTableContent(dt);
}
}
}
}