---
title: "What are major difference between classic ADO and ADO.NET?"  
description: "What are major difference between classic ADO and ADO.NET?"  
author: "Sumit Kesarwani"  
published: 2014-08-21  
updated: 2020-09-24  
canonical: https://www.mindstick.com/interview/1968/what-are-major-difference-between-classic-ado-and-ado-dot-net  
category: "ado.net"  
tags: ["ado.net"]  
reading_time: 1 minute  

---

# What are major difference between classic ADO and ADO.NET?

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.

## Answers

### Answer by Sumit Kesarwani

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.


---

Original Source: https://www.mindstick.com/interview/1968/what-are-major-difference-between-classic-ado-and-ado-dot-net

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.