What is ado.net?

  By Nauman Shafi   Posted on July-08-2023   60


  • ADO.NET (ActiveX Data Objects .NET) is a set of data access components provided by Microsoft as part of the .NET Framework

  • ties for configuring connection settings.

  • Command: A Command object represents a query or command to be executed against a data source. It allows you to execute SQL statements or stored procedures and retrieve results.

  • DataAdapter: A DataAdapter object acts as a bridge between a DataSet (an in-memory representation of data) and a data source. It populates the DataSet with data retrieved from the database and updates the database with changes made to the DataSet.

  • DataSet: A DataSet object represents an in-memory cache of data that can hold multiple tables, relationships, and constraints. It provides a disconnected, cached representation of data that can be manipulated independently of the data source.

  • ADO.NET also includes support for transaction management, data binding, and XML integration. It is widely used in developing data-driven applications and provides a powerful and flexible framework for working with data in .NET-based applications.


  • DataReader: A DataReader object provides a forward-only, read-only stream of data from a data source. It is optimized for retrieving large result sets and enables efficient data access by reading data one row at a time

  • . It is a technology used for connecting applications to databases and performing data manipulation tasks. ADO.NET provides a consistent programming model for accessing and managing data from a wide variety of data sources, including relational databases, XML documents, and more.

ADO.NET offers a range of classes and namespaces that facilitate database operations. The core components of ADO.NET include:

  1. Connection: A Connection object represents a connection to a data source, such as a database server. It provides methods for establishing and closing connections, as well as proper.


By      08-Jul-2023 Views  60

You may also read following recent Post

Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links