Differences between ADO and ADO. NET

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.