---
title: "What is difference between dataset and datareader?"  
description: "What is difference between dataset and datareader?"  
author: "Sumit Kesarwani"  
published: 2014-01-27  
updated: 2020-09-19  
canonical: https://www.mindstick.com/interview/1885/what-is-difference-between-dataset-and-datareader  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# What is difference between dataset and datareader?

DataReader provides forward-only and read-only access to data, while the DataSet object can hold more than one table (in other words more than one rowset) from the same data source as well as the relationships between them.

Dataset is a disconnected architecture while datareader is connected architecture.

Dataset can persist contents while datareader can not persist contents, they are forward only.

## Answers

### Answer by Sumit Kesarwani

DataReader provides forward-only and read-only access to data, while the DataSet object can hold more than one table (in other words more than one rowset) from the same data source as well as the relationships between them.

Dataset is a disconnected architecture while datareader is connected architecture.

Dataset can persist contents while datareader can not persist contents, they are forward only.


---

Original Source: https://www.mindstick.com/interview/1885/what-is-difference-between-dataset-and-datareader

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