Differences between ADO and ADO. NET

1. Introduction to ADO and ADO. NET
ADO and ADO. NET is both similar and different. They are able to write applications that access and operate data on database servers, and are easy to use, fast, low-memory, and occupy less disk space, supports the creation of Client/Server-based and Web-based applications. However, ADO uses ole db interfaces and is based on Microsoft's COM technology, while ADO. NET has its own ADO. NET interface and is based on Microsoft's. NET architecture. As we all know, the. NET system is different from the COM system, and the ADO. NET interface is completely different from the ADO and ole db interfaces. That is to say, ADO. NET and ADO are two data access methods.
2. History of data access methods
Next, let's briefly review several stages of Microsoft's data access methods.
ODBC-(Open Database Connectivity) is the first data access technology to access different relational databases using SQL. ODBC applications can be used to manipulate different databases through a single command. What developers need to do is to add the corresponding ODBC driver to different applications.
Unlike ODBC, DAO-(Data Access Objects) is intended for C/C ++ programmers. It is a simple Data Access method provided by Microsoft to Visual Basic developers, used to manipulate the Access database.
RDO-when using DAO to access different relational databases, the Jet engine had to convert commands between DAO and ODBC, leading to performance degradation, while RDO (Remote Data Objects) the appearance.
Ole db-as more and more data is stored in non-relational format, a new architecture is required to provide seamless connection between such applications and data sources, based on COM (Component Object Model) ole db came into being.
ADO-the ADO Based on ole db is simpler, more advanced, and more suitable for Visual Basic programmers. It eliminates the various drawbacks of ole db and is replaced by the Development Trend of Microsoft technology.

ADO architecture chart
3. Comparison between ADO and ADO. NET
At the beginning of designing the. NET architecture, Microsoft decided to re-design the data access model so that it could be fully based on the XML and offline computing models. The main differences between the two are:
ADO is stored in Recordset, while ADO. NET is represented in DataSet. The Recordset looks more like a single table. If you want the Recordset to be represented in multiple tables, you must connect multiple tables in SQL. Instead, DataSet can be a set of multiple tables. The operation of ADO is an online method, which means that both browsing and updating data must be real-time. ADO. NET is used offline, ADO. NET will use XML to make a copy of the data, ADO.. NET databases must be connected online only during this period.
Since ADO uses the COM technology, this requires that the data type used must comply with the COM specification, while ADO. NET is based on the XML format, and the data types are more abundant and do not need to be converted due to the COM orchestration, thus improving the overall performance.
The following figure depicts the ADO. NET System.

ADO. NET architecture chart
4. Summary
ADO. NET provides an Optimized Data Access Model for the. NET architecture. It is similar to the COM-based ADO.