英文一原文:
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.
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 mand , ADO. NET also add a lot of new object and program melt interface, such as DataSet, DataView, DataAdapter, DataReader and mand etc..It make more simple to operate the database.
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 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.
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 fo
外文文献翻译 来自淘豆网m.daumloan.com转载请标明出处.