Register now or log in to join your professional community.
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.