Best method for Populating DataSet from a SQLDataReader

Question

I am working on a DAL that is getting a DataReader Asynchronously.

I would like to write a single method for transforming the DataReader into a DataSet. It needs to handle different schema so that this one method will handle all of my fetch needs.

P.S. I am populating the SQLDataReader Asynchronously, please don't give answers that are getting rid of the DataReader.

Solution 1

Try DataSet.Load(). It has several overloads taking an IDataReader.

Solution 2

DataTable.load() can be used for a generic approach.

do {
    var table = new DataTable();
    table.Load(reader);
    dataset.Tables.Add(table);
} while(!reader.IsClosed);

Comments

[Andrew Harry]

Ended up using a DataTable (which has the same method)

[KolA]

it needs string[] or DataTable[] as third parameter. Is there any way to populate initially empty DataSet with no tables without knowing its schema beforehand? It also looks like this solution is partially blocking as DataSet.Load() won't take advantage of ReadAsync() and NextResultAsync() methods of SqlDataReader

[mcNux]

This is the answer to the question asked. Thanks.