---
title: "Define connected and disconnected data access in ADO.NET?"  
description: "Define connected and disconnected data access in ADO.NET?"  
author: "Pushpendra Singh"  
published: 2010-10-25  
updated: 2020-09-21  
canonical: https://www.mindstick.com/interview/126/define-connected-and-disconnected-data-access-in-ado-dot-net  
category: "db2"  
tags: ["db2"]  
reading_time: 1 minute  

---

# Define connected and disconnected data access in ADO.NET?

**Connected data** access through the DataReader objects of data provider. This object requires exclusive use of the connection object. It can provide fast and forward-only data access. It doesn't allow editing.\
\
**Disconnected data** access is achieved through the DataAdapter object. This object establishes connection, executes the command, load data in the DataSet. The dataset works independent of database. It contains data in the memory and can edit the data. The changes in the data can be transmitted to the database using Update method of DataAdapter object. \

## Answers

### Answer by Rajesh Goswami

**Connected data** access through the DataReader objects of data provider. This object requires exclusive use of the connection object. It can provide fast and forward-only data access. It doesn't allow editing.\
\
**Disconnected data** access is achieved through the DataAdapter object. This object establishes connection, executes the command, load data in the DataSet. The dataset works independent of database. It contains data in the memory and can edit the data. The changes in the data can be transmitted to the database using Update method of DataAdapter object. \


---

Original Source: https://www.mindstick.com/interview/126/define-connected-and-disconnected-data-access-in-ado-dot-net

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