What is ADO.NET
ADO.NET is a collection of classes that expose data access services. It offers a wide range of components for building distributed, data-sharing applications. It is an essential part of the .NET Framework that enables access to relational, XML, and application data.
When using ADO.NET, you can connect to a certain data source by providing the required authentication details in a connection string by using a Connection object. Depending on the kind of data source, you utilize a particular Connection object.
Initialization data is stored in a connection string. It is delivered as a parameter from the data provider to the data source. The data source sets up further connections and performs additional validation.
ADO.NET uses connection pooling, an optimization approach that reduces the expense of repeatedly establishing and closing connections, to minimize the cost of opening connections.
A single query against a database can be run using the ADO Command object. The query can make changes to records by adding, obtaining, removing, or updating them.
DataAdapter and DataReader
Using the ADO.NET DataReader, you can get a stream of data that is read-only and forward-only from a database. The DataAdapter is used to get information from a data source and fill tables in a DataSet.