ADO. NET is designed for solving the Web and program problem about the distribution application by Microsoft. As a kind of visit frame of database, ADO. NET can handle the N layer's data architecture which doesn't join that Web application program requires, thus when visiting the database of SQL SERVER, superior performance has gotten extensive application. This paper discusses for this.
I.The major object of ADO.NET.
Many objects in ADO.Net is similar to the object function in ADO , but the function of the object in ADO.NET is more powerful. At the same time, except the objects of the Connection, Parameter and Command , ADO. NET also add a lot of new object and program melt interface, such as DataSet, DataView, DataAdapter, DataReader and DataSetCommand etc..It make more simple to operate the database.
I.a DataSet object: DataSet is the core of ADO.NET, is specially used to handle the data which is read out from the stock , and keep it in local memory as away from line. We can use identical way to operate the data which is got from the different data source, the behavior of DataSet is consistent whatever the base layer database is SQL Server or Oracle. In


ADO.NET 是Microsoft 為解決Web 和分布式應(yīng)用程序問題而設(shè)計(jì)的。作為一種數(shù)據(jù)庫訪問框架, ADO.NET 能處理當(dāng)今N 層的Web應(yīng)用程序所要求的非連接數(shù)據(jù)體系結(jié)構(gòu), 因而在訪問SQL SERVER數(shù)據(jù)庫時(shí), 性能優(yōu)越, 得到了廣泛應(yīng)用。本文對(duì)此進(jìn)行了討論。
一、ADO.NET 的主要對(duì)象
ADO.NET 中有很多對(duì)象與ADO 中的對(duì)象功能相似, 但ADO.NET 中對(duì)象的功能更強(qiáng)大。同時(shí), 除Connection、Parameter、Command對(duì)象外ADO.NET 還添加了許多新的對(duì)象和程序化接口, 如DataSet 、DataView、DataAdapter、DataReader、DataSetCommand 等,
使得對(duì)數(shù)據(jù)庫的操作更簡單。
1、DataSet 對(duì)象: DataSet 是ADO.NET 的核心, 是專門用來處理從數(shù)據(jù)存儲(chǔ)中讀出的數(shù)據(jù), 并以離線方式存在于本地內(nèi)存中?？梢允褂孟嗤姆绞絹聿僮鲝牟煌瑪?shù)據(jù)來源取得的數(shù)據(jù), 不管底層的數(shù)據(jù)庫是SQL Server 還是Oracle, DataSet 的行為都是一致的。在DataSet 中可以包含任意數(shù)量的DataTable, 且每個(gè)DataTable 對(duì)應(yīng)一個(gè)數(shù)據(jù)庫的Table 或View。一般來說, 一個(gè)對(duì)應(yīng)