ADO and Ado.net

Source: Internet
Author: User
Tags odbc object model ole one table access database
ADO ADO and Ado.net

--------------------------------------------------------------------------------

Summary
ADO and Ado.net are a high performance access information source strategy offered by Microsoft, which makes it easy for enterprises to consolidate multiple data sources and create maintainable solutions.

--------------------------------------------------------------------------------

Directory
1. ADO and Ado.net Introduction
2. History of data access methods
3. ADO and Ado.net Control
4. Summary

--------------------------------------------------------------------------------

1. ADO and Ado.net Introduction
There are similarities and differences between ADO and Ado.net, both of which are able to write applications that access and manipulate data in the database server, and are easy to use, high speed, low memory expense, and less disk space, and support the primary functionality for building client/server and WEB based applications. But 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. Known. NET system is different from COM system, ADO. NET interface is completely different from the ADO and OLE DB interfaces, which means that ado.net and ADO are two ways of accessing data.

--------------------------------------------------------------------------------

2. History of data access methods
Here's a quick look at several stages of Microsoft's data access approach.
odbc– (Open Database connectivity) is the first data access technology that uses SQL to access different relational databases. Using an ODBC application allows you to manipulate different databases with a single command, and developers need to do just that by adding the appropriate ODBC drivers to different applications.
DAO-(data access Objects), unlike ODBC, is a simple data access method that Microsoft provides to Visual Basic developers to manipulate an Access database, as it does for C + + programmers.
rdo– when using DAO to access different relational databases, the jet engine had to make a command transition between DAO and ODBC, resulting in performance degradation, and RDO (Remote Data Objects) was a logical occurrence.
Ole db– as more and more data is stored in a relational format, a new architecture is needed to provide seamless connectivity between this application and the data source, and OLE DB based on COM (Component Object Model) has emerged.
ado– based on OLE DB, ADO is simpler, more advanced, and more suitable for Visual Basic programmers, while eliminating the many drawbacks of OLE DB and replacing it with the development trend of Microsoft technology.


ADO Schema Diagram

--------------------------------------------------------------------------------

3. ADO and Ado.net Control
At the beginning of the design. NET architecture, Microsoft decided to redesign the data access model so that it could be fully xml-based and off-line. The main differences between the two are:
ADO is stored as a recordset, while Ado.net is represented by a dataset. The recordset looks more like a single table, and if the recordset is represented in more than one table, it must be a multiple table connection in SQL. In contrast, a dataset can be a collection of multiple tables. The operation of ADO is an online approach, which means that both browsing and updating data must be real-time. Ado. NET uses the off-line method, when accesses the data ado.net will use the XML to produce the data the picture, the Ado.net database connection also only then needs the on-line.
Because ADO uses COM technology, this requires that the data types used must conform to COM specifications, and that Ado.net is based on XML format, has a richer data type and does not require the conversion of data types caused by COM choreography, thereby improving overall performance.
Here's how the Ado.net system is depicted in the form of graphs.


Ado. NET schema diagram

--------------------------------------------------------------------------------

4. Summary
Ado. NET provides an optimized data access model for the. NET architecture, and COM based ADO is a completely different way of accessing data.


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.