Shulou(Shulou.com)06/02 Report--

This article focuses on "how to deal with ADO and ADO.NET". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to deal with ADO and ADO.NET.

ADO.NET unifies the data container class programming interface so that no matter what application you plan to write, windows forms, web forms, or web services, can process data through the same set of classes. Regardless of the number of data sources in the backend sql server database

There are both similarities and differences between 1.ADO and ADO.NET. Both of them can write applications that access and manipulate data in the database server, and they are easy to use, high speed, low memory expenditure and less disk space, and support the main functions for building client / server-based and Web-based applications. But ADO uses the OLE DB interface 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. It is well known that the .NET architecture 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 and ADO.NET data access methods.

two。 History of data access methods

Here is a brief review of the stages of Microsoft's data access approach.

ODBC-(Open Database Connectivity) is a data access technology that uses SQL to access different relational databases. Using ODBC applications, you can manipulate different databases with a single command, and developers only need to add corresponding ODBC drivers for different applications.

DAO-(Data Access Objects), unlike ODBC, is intended for Visual Basic developers. It is a simple data access method that Microsoft provides to Access developers for manipulating Access databases.

RDO-when using DAO to access different relational databases, the Jet engine has to convert commands between DAO and ODBC, resulting in performance degradation, and the emergence of RDO (Remote Data Objects) makes sense.

OLE DB-as more and more data are stored in non-relational formats, a new architecture is needed to provide seamless connectivity between applications and data sources. COM (Component Object Model)-based OLE DB for ADO and ADO.NET arises at the historic moment.

ADO-ADO based on OLE DB is simpler, more advanced, and more suitable for Visual Basic programmers. At the same time, it eliminates many disadvantages of OLE DB and replaces the trend of Microsoft technology development.

3. Comparison between ADO and ADO.NET

At the beginning of designing the .NET architecture, Microsoft decided to redesign the data access model so that it could be based entirely on the XML and offline computing models. The main differences between the two are:

ADO is stored as Recordset, while ADO.NET is represented as DataSet. Recordset looks more like a single table, and if you want Recordset to be represented as multiple tables, you must do multi-table joins in SQL. Conversely, a DataSet can be a collection of multiple tables. ADO operates online, which means that both browsing and updating data must be real-time. ADO.NET uses offline mode. When accessing the data, ADO.NET uses XML to make a copy of the data, and the database connection of ADO.NET needs to be online only during this period of time.

Because ADO uses COM technology, this requires that the data types used must conform to the COM specification, while ADO.NET is based on XML format, the data types are more abundant and do not need to do the data type conversion caused by COM choreography, thus improving the overall performance.

At this point, I believe you have a deeper understanding of "how to deal with ADO and ADO.NET". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.