Where to use dataset and datareader. What is recommended

Question

Possible Duplicate:
What's better: DataSet or DataReader?

I have gone through the basics (advantage and disadvantages) of the data set and data reader. But for my application which should i use. If it requires lots of data to be retrieved. I can do this by both way. So the question is that which is appropriate?

See http://stackoverflow.com/questions/1083193/whats-better-dataset-or-datareader and http://stackoverflow.com/questions/2250/datatable-vs-dataset — Eric Lennartsson, Sep 20 '12 at 09:29

score 2 · Accepted Answer · answered Sep 20 '12 at 09:25

2

If you execute just select on your queries, you can use ExecuteDataReader

in order to increase your performance.

Link MSDN about performance report : http://msdn.microsoft.com/en-us/library/ms978388.aspx

answered Sep 20 '12 at 09:25

Aghilas Yakoub

28,516
5
46
51

Where to use dataset and datareader. What is recommended

1 Answers1