Shulou(Shulou.com)06/02 Report--

This article mainly explains "what is the use of .NET Framework and DataSet of ADO.NET structure". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what is the use of .NET Framework and DataSet of ADO.NET structure"?

The two main components of the ADO.NET structure for accessing and manipulating data are the .NET Framework data provider and DataSet.

The .NET Framework data provider is a component designed for data manipulation and fast, forward-only, read-only access to data. The Connection object provides a connection to the data source. Use the Command object to access database commands that return data, modify data, run stored procedures, and send or retrieve parameter information. DataReader provides high-performance data streams from data sources. * DataAdapter acts as a bridge between DataSet objects and data sources. DataAdapter uses the Command object to execute SQL commands in the data source to load data into DataSet and reconcile changes to the data in DataSet back to the data source.

ADO.NET DataSet is specifically designed for data access independent of any data source. Therefore, it can be used for a variety of different data sources, for XML data, or for managing data local to the application. A DataSet contains a collection of one or more DataTable objects that consist of data rows and columns, as well as primary keys, foreign keys, constraints, and relational information about the data in the DataTable object. For more information, see DataSet, DataTable, and DataView (ADO.NET).

The following figure illustrates the relationship between the .NET Framework data provider and DataSet.

ADO.NET structure

When deciding whether your application should use DataReader or DataSet, you should consider the type of functionality required by your application. Use DataSet to do the following:

◆ caches the data locally in the application so that the data can be processed. If you only need to read the query results, DataReader is the better choice.

◆ remotes data between tiers or from XML Web services.

◆ dynamically interacts with data, such as binding to Windows forms controls or combining and associating data from multiple sources.

◆ performs a lot of processing on the data without the need to maintain an open connection to the data source, thus releasing the connection to other clients.

If you do not need the functionality provided by DataSet, you can improve the performance of your application by using DataReader to return data in a forward-only, read-only manner. Although DataAdapter uses DataReader to populate the contents of DataSet (see populating datasets from DataAdapter (ADO.NET)), using DataReader can improve performance because it saves the memory used by DataSet and eliminates the processing required to create DataSet and populate its contents.

Thank you for reading, the above is the content of "what is the use of .NET Framework and DataSet of ADO.NET structure". After the study of this article, I believe you have a deeper understanding of the use of .NET Framework and DataSet of ADO.NET structure, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.