---
title: "Discuss the  main difference between classic ADO and ADO.NET ?"  
description: "Discuss the  main difference between classic ADO and ADO.NET ?"  
author: "Sunil Singh"  
published: 2017-07-10  
updated: 2020-09-19  
canonical: https://www.mindstick.com/interview/23275/discuss-the-main-difference-between-classic-ado-and-ado-dot-net  
category: "asp.net"  
tags: ["ado.net", "asp.net"]  
reading_time: 2 minutes  

---

# Discuss the  main difference between classic ADO and ADO.NET ?

Main difference between classic ado and ado.net is as follows

## ADO

Classic ADO have recordset

Its objects communicate in binary mode

ADO supports mostly connection oriented models

Since ADO derives information about data implicitly at run time based on metadata, it is an expensive process.

Only Client Side Cursors are allowed in ADO classic.

## ADO.Net

ADO.Net have Data Adapter and Data set

ADO.NET uses XML for passing the data

ADO.Net works in Disconnected manner

By leveraging known meta data at design time, ADO.Net provide better runtime performance and more consistent runtime behaviour

ADO.Net Support both client side and server side cursors

## Answers

### Answer by Sunil Singh

Main difference between classic ado and ado.net is as follows

## ADO

Classic ADO have recordset

Its objects communicate in binary mode

ADO supports mostly connection oriented models

Since ADO derives information about data implicitly at run time based on metadata, it is an expensive process.

Only Client Side Cursors are allowed in ADO classic.

## ADO.Net

ADO.Net have Data Adapter and Data set

ADO.NET uses XML for passing the data

ADO.Net works in Disconnected manner

By leveraging known meta data at design time, ADO.Net provide better runtime performance and more consistent runtime behaviour

ADO.Net Support both client side and server side cursors


---

Original Source: https://www.mindstick.com/interview/23275/discuss-the-main-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.