Virtuoso Open-Source Wiki
Virtuoso Open-Source, OpenLink Data Spaces, and OpenLink Ajax Toolkit
Advanced Search
Help?
Location: / Dashboard / Main / VOSIndex / VirtAdoNet35Provider

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.

Benefits

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

Features

  • ADO.NET 3.5 compliance
  • .NET Entity Frameworks compatibility
  • Full integration with Visual Studio 2008
  • ADO.NET Data Services compatibility
  • LINQ to Entities compatibility
  • High-Performance & Scalability
  • High Security
  • Support for Native and 3rd party RDBMS engines and Web Services
  • Tested against all major .NET applications and development environments
  • Support for Microsoft Silverlight versions 2 and 3
  • Support for .NET RIA Services

How Do I Use It?

Installation

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

Powered By Virtuoso