Two basic components of the ADO. Net Object Model

 

The two basic components of the ADO. Net object model are generally:

 

One is a dataset, which is disconnected from the data source and does not need to know the source of the maintained data;

The other is the. NET data provider. the. NET data provider can connect to the data source and execute SQL commands for the data source.

 

The data provider component has multiple versions to access the ODBC database, oledb database, SQL Server database, and Oracle database respectively. That is to say, the data provider component is used as a component for accessing the database.

 

Another component of ADO. NET is dataset.

It corresponds to the recordset of ADO, but the two are different in two important aspects:

First, dataset is normally disconnected, so it does not care about the data source. The disconnected data access model first connects to the database, obtains the required data, and then disconnects from the database, process Data Offline in dataset. this provides a high scalability for applications, because this model allows multiple customers to connect to the database to retrieve data, which is very important in Web applications, because thousands of customers may request data at the same time. To connect dataset to the data source, you must use the dataadapeter component as the intermediary between dataset and. NET data providers to retrieve data from the database.

Second, the important difference between dataset and ADO record sets is that dataset can contain multiple data tables and tables can be stored in different databases. here, dataset specifically proposes the able class to process data tables.

 

 

 

 

Another important aspect of the ADO. NET architecture is that the dataset component uses. net
The. dataset component of the XML class designer in the framework uses XML to store and operate data in the background. It is an ideal way to transmit data between programs and computers.

 

 

In general, the ADO. NET architecture can be divided into two main components: one is the data provider component and the other is the dataset (Dataset)

 

I finally finished writing.

The following is an article about the differences between ADO and ADO. net ..

 

I suggest you use your study notes ..