What are managed providers

This enforces a common interface for accessing data. It simplified data access architecture that often results in improved performance without the loss of functional capabilities.

The .NET Framework by default carries two Managed Providers, SQL Managed Provider and OleDB Managed Provider. The SQL Managed Provider to deal specifically with the Microsoft SQL Server and OleDB Managed Provider to deal with data sources having OleDb connectors. The SQL Server managed provider comes with SqlConnection , SqlCommand , and SqlDataReader. The OLE DB managed provider comes with a similar set of objects, whose names start with OleDb instead of Sql. In both cases, the programming model is essentially the same. The providers abstract the functionality and handle all the heavy lifting under the hood. Both of the providers live in the System.Data namespace.


You can study more about .Net Managed Data Providers in details from the following link:

C# ADO.Net Data Providers     VB.Net ADO.Net Data Providers