⟩ Can you please explain the difference between Dataset and Datareader?
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