What are the benefits of ADO.NET?

 Posted by Abhisek on 1/21/2010 | Category: ADO.NET Interview questions | Views: 9421


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.

2>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 RecordSet.

As ADO.NET transmits the data using the format of XML which is not dependent on ADO.NET or windows platform.

4>Strongly Typed Fields:-
It supports strongly typed fields by using CTS.

The performance in ADO.NET is higher in comparison to ADO that uses COM marshalling.

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

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response