ADO.NET and its Features

ADO.NET is a technology used for working with data and databases of all types .It provides access to data sources such as Microsoft SQL Server, data sources exposed through OLE DB, and eXtensible Markup language (XML). We can use ADO.NET to connect to data sources for retrieving, manipulating, and updating data.
Some features of ADO.NET are as follows:

• Disconnected Data Architecture- Implies that application connected to the database only when data needs to be retrieved or modified. After the database operation has been performed, the connection to the database is closed.To perform any database operation again, the connection with the database will have to re-established.
• Cached Data in Datasets- follows a disconnected architecture for accessing or modifying data.it is not required for the application to connect to the database for processing each record. Therefore, the data is accessed and later stored in the datasets. A dataset is a cached set of database records, which is independent of data source.
• Scalability- Reduces the traffic on database and save the resources to make the database more efficient in meeting the demands of the user. ADO.NET helps in attaining scalability while working with datasets.
• Transfer Of Data In XML Format- Transfers data from a database into a dataset and from the dataset to another component using XML, which is the standard format used for transferring data in ADO.NET.
• Interaction with the Database through Data Commands- Specifies that database operations are performed by  executing the data commands. All operations on database, such as retrieving, modifying, or updating of data are performed using data commands.