Implementation of asynchronous methods on SqlDataAdapter (support for async/await).
The implementation is based on source code provided by Microsoft on GitHub.
- Branch
DotNetSourcecontains original Microsoft .NET sources to simplify resynchronization. Comments contains original sources. - Only read operations are now supported. Feel free to contribute with the rest.
https://www.nuget.org/packages/AsyncDataAdapter/
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 dt = new DataTable();
var r = await a.FillAsync(dt);
}
}
}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);
}
}
}