Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by Waris Ali , Sr. Software Analyst , Iprocess Data
Date Posted: 2013/09/21
Atif Subzwari
by Atif Subzwari , Technical Lead , Wipro Technologies

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.

It’s a disconnected model so they are no more applicable.

 

Locking is not supported due to disconnected model.

 

 

ADO objects communicate in binary mode whereas ADO.NET uses XML for passing the data.

More Questions Like This