VB .Net Developer Interview Question:

Can you please explain the difference between Dataset and Datareader?

Submitted by: Administrator

DataReader:
★ Datareader has read only access to the data and it is set to be forward only.
★ Datareader cannot persist contents as it is read only
★ Datareader is connected architecture

Dataset:
★ Dataset can hold more than one table from the same data source. It even stores relationships between tables.
★ Dataset can persist contents
★ Dataset is disconnected architecture
Submitted by: