英文一原文：
ADO. Net Technology
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 .
Many objects in is similar to the object function in ADO , but the function of the object in 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 , 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 DataSet, it can contain arbitrary quantity of DataTable, and every DataTable is in correspondence with Table or View in darabase. Generally speaking,a corresponding DataTable is a set of a group of DataRow and DataColumn for the data sheet of elephant.DataTable can take the responsibility for defending each data trip to retain it's initial state and current state, with the concurrent that solves database visit problem. reduce the pressure of being away from line to join pattern decreasing for data server.
I.b DataReader object: When looking over mass data with the way that glanced over , it will occupy plenty of memories and cause performance to drop.
For instance,when a link (Connection ) reads the record of 1000 lines of database by using the traditional ADO Recordset ,it must give this link memory distribution for this 1000 lines of record untill the life period of this link finish. If there are many users carrying out the same operation for same computer at the same time,the memory will be used out. To solve these problems, DotNET frame has offered DataReader object, from database,it return a read-only string, which can roll downward only to flow ( Strem ), and exists a record every time only in courently.
I.c DataView object: DataView object representative one DataTable approach by looking over , it is to put data in order with the form of form that what data acquiesce in look over way, and the order of data that put data in order follow the order taking out the trip that put litre and the fence position of row order in order from database data sheet, usually it is concerned with the Sort Order or reduce power in inquiring string when design the database .ADO. NET offer the way that has elasticity very
