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

Here's some good info:

Code: Convert DataReader to DataSet

Answer 2

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