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

This article is about what AOP.NET DataAdapter objects mean. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

AOP.NET DataAdapter objects represent a set of data commands and a database connection to populate DataSet objects and update data sources. As a bridge between the DataSet object and the data source, the DataSet is populated with data by the mapping Fill () method, and the changes in the DataSet object are updated to the database by the Update () method. These operations are actually implemented by four Command named objects, Select, Update, Insert, and Delete, which are contained in the AOP.NET DataAdapter object. It can also be directly combined with the use of Command objects to complete data manipulation. See the figure for how the AOP.NET DataAdapter object works:

Working schematic diagram of DataAdapter object

When the client application needs to process data from the data source, a connection is established between the client application and the data source. The DataAdapter object that references the data command sends a data command request to the data source, which is sent and executed by the data source when the Fill () method of the DataAdapter object is executed to complete the "fill" operation. The data from the data source is populated into the DataSet object on the client side, and a data table DataTable object with the same data structure as the data source is formed inside the DataSet object, while the DataTable object contains a collection of DataColumn objects representing the data structure and a collection of Constraint objects representing data constraints, as well as a collection of DataRow objects representing data records. After the data and data structures are populated into the DataSet object, the DataSet dataset is equivalent to an offline database, and the data operated by the client application is completely fetched from the DataSet dataset. This means that the client DataSet dataset can be disconnected from the data source, that is, the relationship between them is a non-* connection. Only when the client completes the data operation and needs to send the data back to the data source, the connection is established again. The DataAdapter object sends a data command request to the data source again, which is sent and executed by the data source when the Update () method of the DataAdapter object is executed to complete the "update" operation. After execution, the connection is disconnected again. The .NET provider and its DataAdapter classes are shown in the table:

Provider program

DataAdapter class

SQL data provider

SqlDataAdapter

OLE DB data provider

OleDbDataAdapter

Oracle data provider

OracleDataAdapter

ODBC data provider

OdbcDataAdapter

Thank you for reading! This is the end of this article on "what does AOP.NET DataAdapter object mean?". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

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.