ADO.NET: What is Difference Between DataSet & DataReader Object

To be specific to the topic and give answer to this question without arguing a lot, following are the differences between DataSet and DataReader objects:

Datareader is connected architecture while Dataset is a disconnected architecture. This means you need to keep the connection open in DataReader to reader from it. Once the connection is closed you cannot read data from DataReader object. On contrast DataSet object works in a disconnected mode. You fill data into DataSet object and then close the connection. After that you can use/read data from this DataSet object any time you like, regardless of the state of current connection.

Read More