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

This article mainly explains "what are the objects of ADO.NET". 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 are the objects of ADO.NET"?

The five main components of ADO.NET object are Connection object, Command object, DataAdapter object, DataSet object and DataReader object.

The parts of these components responsible for establishing online and data operations are called data manipulation components (Managed Providers), which are composed of Connection objects, Command objects, DataAdapter objects, and DataReader objects, respectively. The data manipulation component is mainly used as a bridge between the DataSet object and the data source, responsible for the work of inserting the data from the data source into the DataSet object and saving the data back to the data source. The five basic object models of ADO.NET objects are described respectively:

1.Connection object

The Connection object is mainly used to open the connection between the program and the database. It is impossible to get data from the database without using the link object to open the database. This object is on the * * layer of ADO.NET. We can generate this object ourselves or automatically by other objects.

2.Command object

Command object can mainly be used to issue some instructions to the database, such as query, add, modify, delete data and other instructions, as well as call stored programs in the database and so on. This object is structured on top of the Connection object, that is, the Command object is linked to the data source.

3.DataAdapter object

The DataAdapter object mainly performs the work of data transfer between the data source and the DataSet. It can issue commands through the Command object and put the obtained data into the DataSet object. This object is structured on top of a Command object and provides a lot of functionality for use with DataSet.

4.DataSet object

The object DataSet can be regarded as a temporary storage area (Cache), which can retain the data queried from the database and even display the entire database. The ability of DataSet is not only to store multiple Table, but also to obtain some data table structures such as primary keys through DataAdapter objects, and to record the associations between data tables. DataSet object can be said to be a heavyweight object in ADO.NET, which is structured on DataAdapter object and does not have the ability to communicate with data source itself; that is to say, we use DataAdapter object as a bridge between DataSet object and data source to transfer data.

5.DataReader object

The DataReader object can be used when we only need to read the data sequentially and no other operations are needed. The DataReader object only reads the data in the data source one stroke at a time, and the data is read-only and no other operations are allowed. Because DataReader is limited to one stroke at a time when reading data, and can only be read-only, it is not only resource-saving but also efficient to use. In addition to being more efficient in using DataReader objects, you can reduce the load on the network because you don't have to send all the data back.

Thank you for your reading, these are the contents of "what are the objects of ADO.NET?" after the study of this article, I believe you have a deeper understanding of what the objects of ADO.NET have, 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.