DataSet and DataReader

Question

Hello

     I want to know that which is more beneficial in DataSet or DataReader as per execution speed.

Answer 1

DataSet will get the entire data at once, while using DataReader you can read record by record.

Some comparisons

http://www.eggheadcafe.com/articles/20030205.asp

http://msdn.microsoft.com/en-us/library/ms978388.aspx

http://articles.sitepoint.com/article/dataset-datareader

http://stackoverflow.com/questions/334658/is-datareader-quicker-than-dataset-when-populating-a-datatable

---

Thanks, A.m.a.L [MVP Visual C#] Dot Net Goodies
Don't hate the hacker, hate the code

Answer 2

The DataReader is much much faster. The DataSet reads and carries over the table(s) schema which contributes heavily to the overhead.

Adam

---

Ctrl+Z