ADO.NET is designed to provide a disconnected architecture.
This means that application connect to the database to retrieve a load of data and store it in memory.
They then disconnect from the database and manipulate the in-memory copy of the data.
If the database needs to be updated with changes made to the in-memory copy, a new connection is made and database is updated.
The main in-memory data store is the dataset, which contains other in-memory data stores, such as DataTable, DataColumn, and DataRow objects.
We can filter and sort data in a DataSet using DataView Objects.