ADO.NET, a Data Access Technology
ADO.NET is a part of the base class library included into the Microsoft .NET Framework. ADO.NET is an array of different classes that open data services to the programmers that use .NET. This technology provides communication between non-relational and relational systems using a common group of components. ADO.NET provides developers who write managed code with functionality similar to that provided by ADO to COM developers. ADO.NET ensures regular access to such data sources as XML and SQL Server, and to data sources that can be exposed through ODBC and OLE DB. Consumer applications that share data can utilize ADO.NET to get connected to such data sources and manage, retrieve, and update their data.
Being an essential part of the .NET Framework, ADO.NET gives developers a good set of various components for building distributed applications that share their data. It enables access to application data, relational data, and XML. ADO.NET can be used for a wide range of development needs that include the building of data base’s front-end clients and creation of middle-tier business objects used by applications, languages, tools, and internet browsers.
In ADO.NET, data access and data manipulation are separated like discreet components and can be used independently or together. The two main components for manipulating and accessing data are the DataSet and the .NET Framework data providers.
.NET Framework data providers were designed to ensure connection to a database and data manipulations such as executing different commands and getting results. The results can be processed instantly, stored in an ADO.NET DataSet object so that the user can view them for a specific purpose as well as combined with data from numerous sources or just passed between tiers. In order to manage data sourced from XML or local to the application, developers can use the DataSet object separately from a .NET Framework data provider.