Difference between classic ADO and ADO DOT NET

Question

Write main difference between classic ADO and ADO.NET?

Answer 1

Some most important differences between classic ADO and ADO.NET are as follows:

ADO contains recordset and ADO.NET have dataset.

Dataset can have multiple tables. In recordset we have only one table. If we desire to hold more than one table,

We require perform do inner join and fill the recordset.

Every data endure in XML as compared to classic ADO where persisted data in Binary format also.