What is ADO.NET ?

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.

Share this article on