• Topic
  • Discussion
  • VOS.VirtAdoNet35Provider(Last) -- DAVWikiAdmin? , 2017-06-29 07:35:57 Edit WebDAV System Administrator 2017-06-29 07:35:57

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

    CategoryDocumentation CategoryVirtuoso CategoryDotNET CategoryEntityFrameworks CategoryWebSite