Search code examples
c#.netado.netdatareader

Where to use dataset and datareader. What is recommended

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?

Solution

  • 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