i

ASP.Net A Complete Guide

ADO.NET [ActiveX Data Object]

It is a framework to provide database access, and it is created by Microsoft. It helps us create a connection between the application and the data sources. Data sources can include the SQL Server and XML. It is a collection of classes that can be used to connect, retrieve, insert, and delete data.

Below are some advantages provided by ADO.net:

  • .Net offers the ado.net component and data-bound control. You need to drag and drop those control and set their property &write events. It helps the programmer to write less code.

  • It provides the disconnected data & you can consider the dataset as a local copy of the database.

  • It provides managed classes. They take advantage of .NET CLR, such as language independency and automatic resource management.

  • ADO .NET data is cached and converted in XML format. All components and applications can share this data. You can transfer those data via HTTP protocols