O'Reilly logo

Visual Basic® .NET by Example by Bob Donald, Gabriel Oancea

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required