---
title: "What are the major components of data provider?"  
description: "What are the major components of data provider?"  
author: "Sumit Kesarwani"  
published: 2014-01-27  
updated: 2020-09-15  
canonical: https://www.mindstick.com/interview/1886/what-are-the-major-components-of-data-provider  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# What are the major components of data provider?

The Connection object which provides a connection to the database.

The Command object which is used to execute a command.

The DataReader object which provides a forward–only, read only, connected recordset.

The DataAdapter object which populates a disconnected DataSet with data and performs update.

## Answers

### Answer by Sumit Kesarwani

The Connection object which provides a connection to the database.

The Command object which is used to execute a command.

The DataReader object which provides a forward–only, read only, connected recordset.

The DataAdapter object which populates a disconnected DataSet with data and performs update.


---

Original Source: https://www.mindstick.com/interview/1886/what-are-the-major-components-of-data-provider

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