.NET Data Providers
A Data Provider supports data access through its own specific implementation that supports a common set of interfaces. In .NET, there are two standard Data Providers: SQL Server Data Provider and OLEDB Data Provider.
The OLEDB Data Provider supports data access through any OLEDB driver. If you have an OLEDB driver installed on your computer, your application can use that driver for accessing data stored in the format that OLEDB driver supports. For example, if you have an Oracle OLEDB driver installed you can write an application in .NET to access data in an Oracle database using the OLEDB Data Provider. You cannot use the SQL Server Data Provider to access data in an Oracle database.
If your application supports SQL Server, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access