Answer:
BENEFITS OF ADO.NET
1>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.
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.
3>Interoperability:-
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.
5>Performance:-
The performance in ADO.NET is higher in comparison to ADO that uses COM marshalling.
6>Firewall:
As in ADO.NET transmission is via XML format, therefore it can pass through firewalls.
Asked In: Many Interviews |
Alert Moderator