.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, ...

Get Visual Basic® .NET by Example now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.