Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     

ADO.NET Interview Question: - What are the major differences between classic ADO and ADO.NET?

Following are some major differences between both :- 

  • In ADO we have recordset and in ADO.NET we have dataset.
  • In recordset we can only have one table. If we want to accommodate more than one tables we need to do inner join and fill the recordset. Dataset can have multiple tables.
  • All data persist in XML as compared to classic ADO where data persisted in Binary format also.

This question is taken from .NET interview questions book.

Also see following video on ADO.NET interview questions on Dataset and Data reader: -
Helpful Website Url
http://www.questpond.com/
Share this article   |    Print    |    Article read by 4770 times
Author:
Shivprasad koirala Koirala I am a Microsoft MVP for ASP/ASP.NET and currently a CEO of a small E-learning company in India. We are very much active in making training videos , writing books and corporate trainings. Do visit my site http://www.questpond.com for .NET, C# , design pattern , WCF , Silverlight , LINQ , ASP.NET , ADO.NET , Sharepoint , UML , SQL Server training and Interview questions and answers
Related Articles:
Related Interview Questions: