Architecture of ADO.NET

Question

Write about the architecture of ADO.NET in brief.

Answer 1

AD0.NET involves two fundamental components:

a) The DataSet, which is disconnected from the data source and does not required to know where the data which it holds is retrieved from.

b) The .net data provider, that allows application to get connected to the data source and execute the SQL commands against it.

The data provider holds the Command, Connection, DataAdapter, and DataReader objects. The Connection object provides connectivity to the database. The Command object provides access to database commands to manipulate and retrieve data in a database. The DataReader object retrieves data from the database in the forward-only and read only mode. The DataAdapter object uses Command objects to implement the SQL commands. The DataAdapter object loads the DataSet object with the data and also update changes that have been made to the data in the DataSet object back to the database.