.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> .Net Framework >> Post New Resource Bookmark and Share   

 Subscribe to Articles

BENEFITS OF ADO.NET

Posted By:Dhivakaran       Posted Date: October 29, 2010    Points: 50    Category: .Net Framework    URL: http://www.dotnetspark.com  

ADO.NET is a collection of classes, interfaces, structures and enumulated types that manages data access from relational data sources with in the .NET framework. These collections are organised into namespaces such as System.Data, System.Data.OLEDB and System.Data.SqlClient.
 

 
  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.
 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend