1.

Differences Between "dataset" And "datareader".

Answer»

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.

Dataset:


Datareader


Discussion

No Comment Found

Related InterviewSolutions