---
title: "What is the role of data provider?"  
description: "What is the role of data provider?"  
author: "Pushpendra Singh"  
published: 2010-10-26  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/186/what-is-the-role-of-data-provider  
category: "ado.net"  
tags: ["ado.net"]  
reading_time: 1 minute  

---

# What is the role of data provider?

The .NET data provider layer resides between the application and the database. Its task is to take care of all their interactions.

The .NET Data provider can be demonstrated to be:

SQL Server data provider \
OLEDB data provider \
ODBC Data Provider

ADO.NET supports the following OLE DB Providers:

- SQLOLEDB - Microsoft OLE DB Provider for SQL Server.\
- MSDAORA - Microsoft OLE DB Provider for Oracle.\
- Microsoft.Jet.OLEDB.4.0 - OLE DB Provider for Microsoft Jet.\

## Answers

### Answer by hanmandlu vasani

The .NET data provider layer resides between the application and the database. Its task is to take care of all their interactions.

The .NET Data provider can be demonstrated to be:

SQL Server data provider \
OLEDB data provider \
ODBC Data Provider

ADO.NET supports the following OLE DB Providers:

- SQLOLEDB - Microsoft OLE DB Provider for SQL Server.\
- MSDAORA - Microsoft OLE DB Provider for Oracle.\
- Microsoft.Jet.OLEDB.4.0 - OLE DB Provider for Microsoft Jet.\


---

Original Source: https://www.mindstick.com/interview/186/what-is-the-role-of-data-provider

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