Home > DeveloperSection > Interviews > What are major difference between classic ADO and ADO.NET?

Posted on    August-21-2014 11:29 PM

 ADO.Net ADO.Net 
Ratings:
 1 Answer(s)
  880  View(s)
Rate this:

Sumit Kesarwani

Total Post:782

Points:3910
Posted on    August-21-2014 12:00 AM

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.


Don't want to miss updates? Please click the below button!

Follow MindStick