Benefits And Aspects Of ADO .NET

ADO stands for ActiveX Data Objects and it relies on COM whereas ADO.NET depend on managed providers defined by the .NET CLR (Common Language Runtime). ADO.NET provides consistent access to data sources such as SQL Server, as well as data sources exposed through OLE DB and XML.

The ADO.NET Framework supports two models of Data Access Architecture, Connection Oriented Data Access Architecture and Disconnected Data Access Architecture. There are some Advantages of ADO.Net:

Scalability: ADO.NET works on Dataset that can represent a whole database or even a data table as a disconnected object and thereby eliminates the problem of the constraints of number of databases being connected. In this way scalability is achieved. To get more information about ADO .Net you can check useful free stuff (also known as ingyen cuccok in Hungarian language) through the internet.

Data Source Independence: In ADO.NET Dataset is completely independent of data source and no way Dataset is controlled by the data source as it happens in case of Record Set.

Interoperability: As ADO.NET transmits the data using the format of XML which is not dependent on ADO.NET or windows platform.
Strongly Typed Fields: It supports strongly typed fields by using CTS.

Performance: The performance in ADO.NET is higher in comparison to ADO that uses COM marshaling.

Firewall: As in ADO.NET transmission is via XML format, therefore it can pass through firewalls.