Overview of ADO.NET

ADO.NET is Microsoft's latest data access technology. As an integral part of the .NET Framework it is far more than simply an upgrade of previous incarnations of ActiveX® Data Objects ADO. ADO.NET provides an extensive set of .NET classes that facilitate efficient access to data from a large variety of sources also enabling sophisticated manipulation and sorting of data, and forming an important framework within which to implement inter-application communication and XML Web Services.

ADO.NET is essentially a collection of classes that expose methods and attributes used to manage communications between an application and a data store. Being an integral part of the .NET Framework, ADO.NET simplifies integration of data sharing in distributed ASP.NET applications.

ADO.NET is an expansion of ADO with some of the key concepts retained. It provides access to structured data from diverse sources, which are all accommodated in a consistent, standardized programming model.

ADO.NET can be used in any consumer application that needs to connect to, and communicate with, data sources such as Microsoft SQL Server™, as well as data sources exposed via OLE DB and XML.

XML is used to exchange data between programs or Web pages, which requires a disconnected or remote access to data. Transmitting information in XML-formatted data sets enables programmers to easily separate the data processing and user interface components of a data-sharing application onto separate servers. This can greatly improve both performance and maintainability for systems supporting many users. Read more...