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

This article mainly talks about "what is the relationship between ADO.NET and OLEDB". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what is the relationship between ADO.NET and OLEDB"?

The working process of 1.ADO.NET controlling the database

The working process of the ADO.NET tutorial .NET data provider is shown in the figure:

Figure. Net data provider working process diagram

In the figure, the three steps are the process of retrieving data from the server, and An and B are the process of modifying the database. Steps 1, 2, and B are all working steps of the .NET data provider in this process.

The relationship between 2.ADO.NET and MS SQL Server

Because the VS2005 software development system platform and SQL Server database management information system based on .NET Framework 2.0 are from Microsoft products, the data communication between VS2005 and SQL Server has been optimized to access SQL Server directly without adding OLE DB or open database connection (ODBC) layer, and has good performance.

The relationship between 3.ADO.NET and OLEDB

OLEDB is a strategic system-level programming interface for Microsoft to manage data throughout the organization. OLEDB is an open specification based on ODBC functions, which is mainly used to access non-relational databases. The table shows the providers that have been tested with ADO.NET.

Driver program

Provider program

SQLOLEDB

Microsoft OLE DB provider for SQL Server

MSDAORA

Microsoft OLE DB provider for Oracle

Microsoft.Jet.OLEDB.4.0

OLE DB provider for Microsoft Jet

Table OLEDB data provider corresponding to the data source driver table

Driver provider

◆ SQLOLEDB Microsoft OLEDB provider for SQL Server

◆ MSDAORA Microsoft OLE DB provider for Oracle

◆ Microsoft.Jet.OLEDB.4.0 OLEDB provider for Microsoft Jet

The OLE DB .NET Framework data provider class is located in the System.Data.OleDb namespace. The following code example shows how to include the System.Data.OleDb namespace in your application.

The relationship between 4.ADO.NET and ODBC

DSN (data source) is set in odbc and is used to connect to databases. ODBC can only be used in relational databases. Database connections as DSN can be divided into the first three types:

◆ user DSN: the data source is local to the computer and can only be accessed by the current user, so only the user who established the data source can access the data source, and cannot access the data source from the network.

◆ system DSN: the data source is also local to the computer, but not user-specific. Any user with permission can access the "system DSN", but it still cannot be accessed from the network.

◆ files DSN: unlike the former two, they can be shared among all users who have the same driver installed, and these data sources are local to the computer. In other words, it can be accessed through the network.

The ODBC .NET Framework data provider class is located in the System.Data.Odbc namespace. The following code example shows how to include the System.Data.Odbc namespace in your application.

5. The relationship between DO.NET and Oracle

The ADO.NET provider enables data access to Oracle data sources through the Oracle client connection software, which supports Oracle client software version 8.1.7 or later. The ADO.NET provider class associated with the Oracle database is located in the System.Data.OracleClient namespace and is included in the System.Data.OracleClient.dll assembly. The following code example shows how to include the System.Data.OracleClient namespace in your application.

Using System.Data; using System.Data.OracleClient; so far, I believe you have a deeper understanding of "what is the relationship between ADO.NET and OLEDB". 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.