This HTML5 document contains 55 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Subject Item

n2:VirtAdoNet35Provider

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T05:38:34.203697

dcterms:modified

2017-06-13T05:38:34.203697

rdfs:label

VirtAdoNet35Provider

foaf:maker

n16:this n20:this

dc:title

VirtAdoNet35Provider

opl:isDescribedUsing

n4:rdf

sioc:has_creator

n10:this n17:this

sioc:content

%VOSWARNING% %META:TOPICPARENT{name="VOSIndex"}% ---+ Virtuoso ADO.NET 3.5 Data Provider %TOC% ---++ 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 [[VirtODBCEntityFrameworkUsage][ODBC]] and/or [[VirtOJDBCEntityFrameworkUsage][JDBC]] accessible data sources. Known-compatible external data sources include [[VirtOracleEntityFrameworkUsage][Oracle (versions 7.x to 11.x)]], [[VirtMSSQLServerEntityFrameworkUsage][Microsoft SQL Server (6.x to 2005)]], [[VirtDB2EntityFrameworkUsage][IBM DB2]], [[VirtSybaseEntityFrameworkUsage][Sybase (4.2 to 15.x)]], [[VirtInformixEntityFrameworkUsage][IBM Informix (5.x to 11.x)]], [[VirtIngresEntityFrameworkUsage][Ingres (6.4 to 9.x)]], [[VirtProgressEntityFrameworkUsage][Progress (7.x to 10.x)]], [[VirtMySQLEntityFrameworkUsage][MySQL]], [[VirtPostgresEntityFrameworkUsage][PostgreSQL]], and [[VirtFirebirdEntityFrameworkUsage][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 [[http://www.microsoft.com/Silverlight/][Microsoft Silverlight]] versions 2 and 3 * Support for [[https://code.msdn.microsoft.com/site/search?query=riaservices%26f%5B0%5D.Value%3Driaservices%26f%5B0%5D.Type%3DSearchText%26ac%3D4][.NET RIA Services]] --++ How Do I Use It? ---+++ Installation There are two installation types to consider. * If you have an existing Virtuoso instance, or will install Virtuoso on a different host, you only need to [[VirtADOClientInstall][install the ADO.NET Provider Client]] on the Visual Studio host. * If you have no existing Virtuoso instance, you can [[VirtADOClientServInstall][install both the ADO.NET Provider Client and the Virtuoso Universal Server]] on the Visual Studio host. ---+++ Connection String The Virtuoso ADO.NET Provider [[VirtADONet35ConnStrings][ConnectionString property]] implements the <nop>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 * [[VirtAdoNetDataGridApp][Using Visual Studio 2008 to Build a Data Grid Form Application]] * [[VirtEntityFrameworkSchoolDbWinFormApp][Using Visual Studio 2008 to Build an Entity Frameworks based Windows Form Application]] * [[VirtUsingMsAdoNetDataServicesWithVirtuoso][Using Visual Studio 2008 to Build an ADO.NET Data Services based Application]] * [[VirtSPASQLWinFormApp][Windows Form Application for accessing Virtuoso RDF data via SPASQL using the Virtuoso ADO.NET Provider]] * [[VirtSPASQLWebDataServiceApp][Web Data Service Application for accessing Virtuoso RDF data via SPASQL using the Virtuoso ADO.NET Provider]] * [[VirtSPASQLSilverLightApp][Creating a Silverlight Application to consume the service]] * [[RIAServicesHowTo][Creating A Simple .NET RIA Services Application to Display Data from Virtuoso]] * [[RIAServicesHowTo2][Creating a .NET RIA Services Application that will Update Virtuoso Data]] * [[VirtSilverlightSPARQLExample][Creating a Silverlight Application for Browsing RDF Data]] * [[ODataServiceExample][Creating an OData Publishing Endpoint using Virtuoso's ADO.NET Data Provider]] * [[VirtRDFODataExample][Accessing RDF Triples as an OData Service]] ---+++ 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 <nop>OpenLink Virtuoso to access schema objects in -- * [[VirtFirebirdEntityFrameworkUsage][Firebird data sources]] * [[VirtDB2EntityFrameworkUsage][IBM DB2 data sources]] * [[VirtInformixEntityFrameworkUsage][IBM Informix data sources]] * [[VirtIngresEntityFrameworkUsage][Ingres data sources]] * [[VirtOJDBCEntityFrameworkUsage][JDBC data sources]] * [[VirtMSSQLServerEntityFrameworkUsage][Microsoft SQL Server data sources]] * [[VirtMySQLEntityFrameworkUsage][MySQL data sources]] * [[VirtODBCEntityFrameworkUsage][ODBC data sources]] * [[VirtOracleEntityFrameworkUsage][Oracle data sources]] * [[VirtPostgresEntityFrameworkUsage][PostgreSQL data sources]] * [[VirtProgressEntityFrameworkUsage][Progress data sources]] * [[VirtSybaseEntityFrameworkUsage][Sybase data sources]] CategoryDocumentation CategoryVirtuoso CategoryDotNET CategoryEntityFrameworks CategoryWebSite

sioc:id

2b9121d75a085e86d047fc92212bd21f

sioc:link

n2:VirtAdoNet35Provider

sioc:has_container

n6:VOS

n13:has_services

n14:item

atom:title

VirtAdoNet35Provider

sioc:links_to

n8:VirtODBCEntityFrameworkUsage n8:VirtOJDBCEntityFrameworkUsage n8:CategoryVirtuoso n8:VirtMySQLEntityFrameworkUsage n8:VirtPostgresEntityFrameworkUsage n8:VirtIngresEntityFrameworkUsage n8:VirtProgressEntityFrameworkUsage n8:VirtSybaseEntityFrameworkUsage n8:VirtInformixEntityFrameworkUsage n8:VirtOracleEntityFrameworkUsage n8:VirtDB2EntityFrameworkUsage n8:VirtADOClientInstall n11:4 n8:CategoryDocumentation n8:VirtRDFODataExample n2:VirtADOClientServInstall n2:VirtMSSQLServerEntityFrameworkUsage n12: n8:VirtSPASQLWebDataServiceApp n8:RIAServicesHowTo2 n8:VirtAdoNetDataGridApp n8:ODataServiceExample n2:VirtSPASQLSilverLightApp n8:VirtFirebirdEntityFrameworkUsage n8:RIAServicesHowTo n2:VirtSilverlightSPARQLExample n8:VirtSPASQLWinFormApp n8:VirtEntityFrameworkSchoolDbWinFormApp n8:VirtUsingMsAdoNetDataServicesWithVirtuoso n8:CategoryDotNET n2:VirtADONet35ConnStrings n8:CategoryEntityFrameworks n8:CategoryWebSite

atom:source

n6:VOS

atom:author

n16:this

atom:published

2017-06-13T05:38:34Z

atom:updated

2017-06-13T05:38:34Z

sioc:topic

n6:VOS