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:
- What are the advantage of ADO.Net
- Differences between classic ADO and ADO.NET
- difference between Dataset and DataReader
- How to ADO.Net Connection Pooling
- How to Transaction in ADO.NET
- What is ADO.Net Locking
- Difference between SqlCommand and SqlCommandBuilder
- Difference between Typed DataSets and UnTyped DataSets