---
title: "Explain the data provider classes that is supported by ADO.NET."  
description: "Explain the data provider classes that is supported by ADO.NET."  
author: "Sunil Singh"  
published: 2017-06-28  
updated: 2020-09-19  
canonical: https://www.mindstick.com/interview/23272/explain-the-data-provider-classes-that-is-supported-by-ado-dot-net  
category: "c#"  
tags: ["ado.net", "asp.net"]  
reading_time: 1 minute  

---

# Explain the data provider classes that is supported by ADO.NET.

.NET framework data provider includes the following components for data manipulation:

**Connection :** Used for connectivity to the data source

**Command :** This executes the SQL statements needed to retrieve data, modify data or execute stored procedures. It works with connection object.It requires instance of connection object.

**DataReader :** This class is used to retrieve data. DataReader is forward only and read-only object. We cannot modify the data using DataReader.

**DataAdapter :** It works as bridge between dataset and data source. DataAdapter uses fill method to load the dataset.

## Answers

### Answer by Sunil Singh

.NET framework data provider includes the following components for data manipulation:

**Connection :** Used for connectivity to the data source

**Command :** This executes the SQL statements needed to retrieve data, modify data or execute stored procedures. It works with connection object.It requires instance of connection object.

**DataReader :** This class is used to retrieve data. DataReader is forward only and read-only object. We cannot modify the data using DataReader.

**DataAdapter :** It works as bridge between dataset and data source. DataAdapter uses fill method to load the dataset.


---

Original Source: https://www.mindstick.com/interview/23272/explain-the-data-provider-classes-that-is-supported-by-ado-dot-net

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