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

This article mainly explains the "ADO.NET connection database method is what", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "ADO.NET connection database method is what" it!

The contents of ADO.NET connecting to the database include connecting to the database, executing database manipulation commands and retrieving results.

The retrieved results can be processed directly, or they can be put into DataSet objects, which can be easily combined with data from multiple sources and remotely processed between tiers and exposed to users in a special way. The .NET Framework data provider is lightweight, creating a minimum layer between the data source and the code to improve performance without sacrificing functionality. Data providers are classified in ADO.NET. Let's take a detailed look at the classification diagram of the .NET data provider in ADO.NET.

Classification Diagram of .NET data provider in ADO.NET

The main objects that ADO.NET controls the database include: Connection object, Command object, DataReader object, DataAdapter object. The table summarizes the four core objects that make up the .NET Framework data provider.

Object

Description

Connection

Establish a connection to a specific data source. The base class of all Connection objects is the DbConnection class.

Command

Execute commands on the data source. The Parameters is exposed and can be executed within the scope of the Transaction through Connection. The base class of all Command objects is the DbCommand class.

DataReader

Reads a forward-only and read-only data stream from the data source. The base class of all DataReader objects is the DbDataReader class.

DataAdapter

Populate the DataSet with the data source and parse the update. The base class of all DataAdapter objects is the DbDataAdapter class.

Four core object tables of .NET data provider

In addition to the ADO.NET core objects listed in the table, the. NET Framework data provider contains other important objects listed in the table

Object

Description

Transaction

Enables you to enlist commands in the transaction of the data source. The base class of all Transaction objects is the DbTransaction class.

CommandBuilder

The helper object will automatically generate command properties of the DataAdapter or will derive parameter information from the stored procedure and populate the Parameters collection of the Command object. The base class of all CommandBuilder objects is the DbCommandBuilder class.

ConnectionStringBuilder

The helper object provides an easy way to create and manage the contents of the connection string used by the Connection object. The base class of all ConnectionStringBuilder objects is the DbConnectionStringBuilder class.

Exception

Returns when an error is encountered in the data source. For errors encountered on the client, the. NET Framework data provider throws a .NET Framework exception. The base class of all Exception objects is the DbException class.

Error

Expose the information in warnings or errors returned by the data source.

ClientPermission

Access security properties for .NET Framework data provider code. The base class of all ClientPermission objects is the DBDataPermission class.

Other object tables for .NET data providers

Thank you for your reading, the above is the content of "what is the method of connecting to the database by ADO.NET". After the study of this article, I believe you have a deeper understanding of what the method of connecting to the database by ADO.NET is, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.