What are the major differences between classic ADO and ADO.NET?

 Posted by Bharathi Cherukuri on 5/21/2012 | Category: ADO.NET Interview questions | Views: 2075 | Points: 40

Following are some of the major differences between both

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

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response