Clear Asp.net (7): Ado. Net Overview

1. Overview of ADO. net

ADO. net is. net Framework comes with a data access technology, ADO. net is composed of managed classes ,.. Net Applications connect to the database through these managed classes, execute commands, and manage non-connected data.

The key difference between ADO. NET and traditional ADO lies in processing different data sources. Ado performs operations on different databases through the same class, while ADO. NET provides different program models for different databases.

. NET Framework has four different providers.

SQL Server Provider-Provides optimized access to SQL Server databases.

Oracle provider-Provides optimized access to the Oracle database.

Ole db provider-provides access to any database driven by ole db.

ODBC provider-provides access to any database driven by ODBC.

 

Ii. namespace of ADO. net

System. Data contains key data container classes

System. Data. Common

System. Data. sqlclient

System. Data. oledb

System. Data. oracleclient

System. Data. ODBC

System. Data. sqltypes contains the types that correspond to the local data types of SQL Server.

 

Iii. Two object types in ADO. net

Ado. Net contains two object types:

1. Connection-based object

A connection-based object is an object provided by data. Such as connection, command, dataadapter, and datareader.

These objects can all be in the namespace specified by the database provider. For example, sqlconnection and system. Data. sqlclient exist.

2. Content-based object

It is basically a data package. For example, dataset, datacolumn, datarow, datarelation, and other data containers.

 

Clear Asp.net series learning blog directory

 

 

Reference: Pro ASP. NET 3.5 in C #2008