Fastest way to populate datatable from database using IDataReader

You saved my day, Thank

good one

nice explanation

Thanks for finding the Errata in the code. I appreciate that. For comparing performance we already have debt on these two. Check'em out here and do mention you findings, it will give others to re-think about Adpater vs Reader: http://stackoverflow.com/questions/1676753/sqldataadapter-vs-sqldatareader http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/c2d762fd-f4a0-4875-8bb8-42f7480e97c8/ :)

Oh My God! I tested and the result is opposite! SqlDataAdapter is FASTER than IdataReader. (I tested with 500 records, 10000 records and 600,000 records)

Thank Amit Choudhary for your helpful article! But i want to discuss a litle about the row: for (int i = 0; i < resultTable.Columns.Count - 1; i++) { dataRow[i] = dataReader[i]; } I think that it'd be better if for (int i = 0; i < resultTable.Columns.Count; i++)

It was Around 500 + records against the Product table of AdventureWorks DB. Well if you want I'll run it against the large records and will update the stats.

Your test was for how many number of records?