Software & Finance





ADO.NET - What is the difference between Dataset and DataReader?





ADO.NET - What is the difference between Dataset and DataReader?

 

Dataset is a wrapper class for datareader. DataSet will wait until the response for given query is completely populated.
DataReader returns as soon as data is available.

 

DataSet can be used when you need to use all the records in one shot. If you are enumerating one by one record in given query. datareader is preferable.