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.

Answer 1

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

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

Answer 2

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