Data Providers

Data providers are .NET objects that allow the .NET Framework to speak with data sources. Data sources are generally databases, such as SQL Server, Oracle, and Access, but also include Microsoft Excel spreadsheets. The .NET Framework includes several built-in data providers exposed by the System.Data namespace. Table 21.1 summarizes built-in data providers.

Image

TABLE 21.1 .NET Data Providers

These are the most common providers, but several companies provided their own, such as MySQL or PostgreSQL. Notice how the OleDb provider is available to provide support for data sources such as Microsoft Access databases or Excel spreadsheets. ...

Get Visual Basic 2015 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.