Differences between DataSet and DataReader.

Differences between “DataSet” and “DataReader”.

Dataset

- DataSet object can contain multiple rowsets from the same data source as well as from the relationships between them

- Dataset is a disconnected architecture

- Dataset can persist data.

- A DataSet is well suited for data that needs to be retrieved from multiple tables.

- Due to overhead DatsSet is slower than DataReader.

Datareader

- DataReader provides forward-only and read-only access to data.

- Datareader is connected architecture. It has live connection while reading data

- Datareader can not persist data.

- Speed performance is better in DataReader.
Explain how to load multiple tables in a DataSet
Load multiple tables in a DataSet using ADO.NET...
What is the use of CommandBuilder?
CommandBuilder builds Parameter objects automatically...
Difference between Optimistic and Pessimistic locking
In pessimistic locking, when a user opens a data to update it, a lock is granted..
Post your comment