DataSet class - A DataSet is basically a container which gets the data from one or more tables from the database. It follows disconnected architecture.
DataAdapter class - A DataAdapter bridges the gap between the disconnected DataSet/ DataTable objects and the physical database.
DataReader Class - The DataReader allows you to read the data returned by a SELECT command.
- It is read only.
- Unlike dataset we cannot update the database via this.
- It follows connected architecture.
Tags:
ADO.NET & EF