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

Editor to share with you what ADO.NET is, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to understand it!

What is ADO.NET?

ADO.NET is a set of object-oriented class libraries for interacting with data sources. Typically, the data source is a database, but it can also be a text file, an Excel table, or an XML file.

ADO.NET allows you to interact with different types of data sources and databases. However, there is no series of classes related to this to accomplish such work. Because different data sources use different protocols, the corresponding protocols must be used for different data sources. Some old data sources use the ODBC protocol, many new data sources use the OleDb protocol, and now there are more and more data sources that can be connected through .NET 's ADO.NET class library.

ADO.NET provides public methods for interacting with data sources, but uses a different set of class libraries for different data sources. These class libraries are called Data Providers and are usually named after the type of protocol and data source with which they interact. Table 1 shows some common data providers, the API prefixes they use, and the types of data sources that allow interaction.

What are the objects contained in ADO.NET:ADO.NET

SqlConnection object

To interact with the database, you must connect to it. The connection help indicates the database server, database name, user name, password, and other parameters required to connect to the database. The connection object is used by the command object so that you can know which database the command is executing on.

The process of interacting with the database means that you have to specify what you want to happen. This is performed by the command object. You use the command object to send SQL statements to the database. The command object uses the connection object to indicate which database to connect to. You can use the command object alone to execute the command directly, or pass a reference to the command object to SqlDataAdapter, which holds a set of commands that can manipulate the set of data described below.

SqlDataReader object

Many data operations require you to read only a string of data. The data reader object allows you to get the results from the SELECT statement of the command object. For performance reasons, the data returned from data reader is fast and only a "forward" data stream. This means that you can only pull data from the data stream in a certain order. This is good for speed, but if you need to manipulate data, a better way is to use DataSet.

DataSet object

A DataSet object is a representation of data in memory. It includes multiple DataTable objects, while DataTable contains columns and rows, just like a table in a normal database. You can even define relationships between tables to create a master-slave relationship (parent-child relationships). DataSet is used in specific scenarios-- to help manage data in memory and support data disconnect operations. DataSet is the object used by all Data Providers, so it doesn't require a special prefix like Data Provider.

SqlDataAdapter object

Sometimes the data you use is mainly read-only, and you rarely need to change it to the underlying data source. Similarly, some situations require caching data in memory to reduce the number of times that unchanged data is called by the database. Data adapter helps you deal with the above situations easily by disconnecting the model. Data adapter populates (fill) the DataSet object when continuous changes to read and write operations to the database in a single batch are returned to the database. Data adapter contains references to connection objects and to automatically open or close connections when reading or writing to a database. In addition, data adapter contains command object references to SELECT,INSERT,UPDATE and DELETE operations on the data. You will define a data adapter for every table in DataSet, which will take care of all connections to the database for you. All you will do is tell data adapter when to load or write to the database.

Summary: ADO.NET is a .NET technology that interacts with data sources. There are many Data Providers that will allow you to communicate with different data sources-depending on the protocol or database they use. However, no matter what Data Provider you use, you will use similar objects to interact with the data source. The SqlConnection object manages the connection to the data source. The SqlCommand object allows you to communicate with the data source and send commands to it. To quickly read data "forward" only, use SqlDataReader. If you want to use disconnected data, use DataSet and implement SqlDataAdapter that can read or write to the data source.

The above is all the content of this article "what is ADO.NET?" thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.