---
title: "Define ADO.Net Architecture in ASP.Net?"  
description: "Define ADO.Net Architecture in ASP.Net?"  
author: "Anonymous User"  
published: 2011-07-04  
updated: 2020-09-18  
canonical: https://www.mindstick.com/interview/1080/define-ado-dot-net-architecture-in-asp-dot-net  
category: "asp.net"  
tags: ["asp.net"]  
reading_time: 2 minutes  

---

# Define ADO.Net Architecture in ASP.Net?

Data access ADO.Net architecture relies on two component first is Data Provider and Second one is Data Set

**DataProvider :** The Data Provider is responsible for providing and maintaining the connection to the database. A DataProvider is a set of related components that work together to provide data in an efficient and performance driven manner. Basically there are four classes which are widely used by Data Provider.

- Connection
- Command
- DataReader
- DataAdapter

**DataSet:** The dataset is a disconnected, in-memory representation of data. It can be considered as a local copy of the relevant portions of the database. The DataSet is persisted in memory and the data in it can be manipulated and updated independent of the database.

## Answers

### Answer by Anonymous User

Data access ADO.Net architecture relies on two component first is Data Provider and Second one is Data Set

**DataProvider :** The Data Provider is responsible for providing and maintaining the connection to the database. A DataProvider is a set of related components that work together to provide data in an efficient and performance driven manner. Basically there are four classes which are widely used by Data Provider.

- Connection
- Command
- DataReader
- DataAdapter

**DataSet:** The dataset is a disconnected, in-memory representation of data. It can be considered as a local copy of the relevant portions of the database. The DataSet is persisted in memory and the data in it can be manipulated and updated independent of the database.


---

Original Source: https://www.mindstick.com/interview/1080/define-ado-dot-net-architecture-in-asp-dot-net

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