Virtuoso ADO.NET 3.5 Data Provider

What is the Virtuoso ADO.NET 3.5 Data Provider?

Virtuoso includes an ADO.NET 3.5 data provider compatible with Visual Studio 2008+ and Entity Frameworks, that provides access to native Virtuoso data (SQL, XML, and RDF) in addition to any DBMS objects linked from external ODBC and/or JDBC accessible data sources. Known-compatible external data sources include Oracle (versions 7.x to 11.x), Microsoft SQL Server (6.x to 2005), IBM DB2, Sybase (4.2 to 15.x), IBM Informix (5.x to 11.x), Ingres (6.4 to 9.x), Progress (7.x to 10.x), MySQL, PostgreSQL, and Firebird.


This provider equips Microsoft .NET based applications, development environments, and programming languages with conceptual entity-based access to native and heterogeneous data sources.


How Do I Use It?


There are two installation types to consider.

Connection String

The Virtuoso ADO.NET Provider ConnectionString property implements the IDbConnection.ConnectionString interface to get or set the string used to open a Virtuoso database connection, and includes the source database name, and other parameters needed to establish the initial connection.

Sample Walk-through Applications

Using Entity Frameworks, ADO.NET, and the Virtuoso Virtual Database Engine

Virtuoso's in-built virtual database engine for ODBC and JDBC accessible databases enables it to act as bridge between Entity Frameworks & ADO.NET based client applications. Thus, you simply link external databases into Virtuoso using the browser based Conductor UI or programmatically using SQL extensions. Once the external tables a linked/attached, they inherit the functionality prowess of Virtuoso, including complete compatibility with Entity Frameworks and ADO.NET 3.5.

We have target-specific guides for using Microsoft Entity Frameworks and OpenLink Virtuoso to access schema objects in --

CategoryDocumentation CategoryVirtuoso CategoryDotNET CategoryEntityFrameworks CategoryWebSite