外文文献翻译------ADO.Net技术.doc
文本预览下载声明
英文一原文:出自 《ado.net 技术》
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 layers data architecture which doesnt 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 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 its initial state and current state, with the concurrent that solves database visit problem. ADO.NET 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
显示全部