Explain the difference between DataSet and DataReader.- Datareader fetches one row at a time from the datasource. DataSet fetches all data from the datasource at a time to its memory area.
- Datareader is like a forward only recordset. We can traverse through an object in a DataSet to get required data.
- DataReader is read only and can be chosen when the network connection is slow. DataSet is always a bulky object that requires lot of memory space compare to DataReader.