Differences between the classic ADO and ADO.NET

Question

Write the major differences between the classic ADO and ADO.NET?

Answer 1

Following are the major differences between both:

a) In ADO we have recordset and in the ADO.NET dataset is there.

b) All data persist in XML as compared to classic ADO where data persisted in Binary format also.

c) In recordset we can have only one table. If we wish to accommodate more than one tables, we requires to do the inner join and fill the recordset. Dataset could have multiple tables.