Ado. NET tutorial (i)

1. What is ADO?

Simply speaking,ADO. NET is a set of technologies that allow. NET developers to interact with data in a standard, structured, and even non-connected way .

The full name of ADO is ActiveX Data Objects, which is an early (. NET has not yet been implemented) the components that developers use to access data. With. NET of development, ADO. NET shun its naturally with its remarkable superiority gradually replace ADO. Technically speaking, ADO uses the OLE DB interface and is based on Microsoft's COM technology, and ADO has its own ADO-based Microsoft. NET Architecture.

Although most new. NET-based applications will be written using ADO,. NET programmers can still use ADO through the. NET COM Interoperability service.

3. Understanding the core components of ADO

The System.Data namespace provides different types of ADO, which are both well-defined and collaborative in providing tabular data access services. The class library contains two important sets of classes: a set of actual data (datasets) that are responsible for processing the internal software, and a set of data Provider that is responsible for communicating with external systems. The specific architecture is as follows:

Another core element of the ADO structure is the. NET Data Provider (Provider). Details include:

• The Connection object provides a connection to the data source.
• The Command object enables you to access database commands that return data, modify data, run stored procedures, and send or retrieve parameter information.
• The DataReader object provides a fast, read-only stream of data from the data source.
• The DataAdapter object provides a bridge that connects a DataSet object to a data source. DataAdapter uses the command object to execute SQL commands in the data source to load data into the dataset and to make changes to the data in the dataset consistent with the data source.

Ado. NET tutorial (i)