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

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

Subject Item

n16:this

foaf:made

n2:VirtEntityFrameworkOODBCDatService

Subject Item

n9:this

sioc:creator_of

n2:VirtEntityFrameworkOODBCDatService

Subject Item

n6:item

n5:services_of

n2:VirtEntityFrameworkOODBCDatService

Subject Item

n8:this

sioc:creator_of

n2:VirtEntityFrameworkOODBCDatService

Subject Item

n10:VOS

sioc:container_of

n2:VirtEntityFrameworkOODBCDatService

atom:entry

n2:VirtEntityFrameworkOODBCDatService

atom:contains

n2:VirtEntityFrameworkOODBCDatService

Subject Item

n2:VirtEntityFrameworkOODBCDatService

rdf:type

atom:Entry sioct:Comment

dcterms:created

2017-06-13T05:48:34.605986

dcterms:modified

2017-06-29T07:37:12.766451

rdfs:label

VirtEntityFrameworkOODBCDatService

foaf:maker

n16:this n20:this

dc:title

VirtEntityFrameworkOODBCDatService

opl:isDescribedUsing

n18:rdf

sioc:has_creator

n8:this n9:this

sioc:attachment

n4:png n21:png n22:png n23:png n24:png

sioc:content

%META:TOPICPARENT{name="VirtODBCEntityFrameworkUsage"}% ---+++Creating an ADO.Net Data Service for ODBC-Compliant Databases An ADO.Net Data Service for the Microsoft Access Northwind tables can be created using the Entity Data Model created in the <i>[[VirtOODBCEDM][Creating EDM in Visual Studio 2008]]</i> section. 1 Open the <b><nop>VirtuosoDataService</b> project created in the <i>[[VirtOODBCEDM][Creating EDM in Visual Studio 2008]]</i> section.%BR%%BR% 1 Right click on the <b><nop>VirtuosoDataService</b> project name in the <b>Solution Explorer</b> pane. Then, select the <b>Add</b> -> <b>New Item</b> menu options. %BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataServices_4.png" style="wikiautogen"/>%BR%%BR% 1 The <b>Add New Item</b> dialog will appear. Choose the <b>ADO.NET Data Service</b> template. Give it the name <b><code>Virtuoso.svc</code></b> and click <b>Add</b> to create the ADO.Net Data Service. %BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataServices_15.png" style="wikiautogen"/>%BR%%BR% 1 In the newly created <b><code>Virtuoso.svc.cs</code></b> Data Service file, add the data source class name of <b><code><nowiki>VirtuosoEntities</nowiki></code></b> (note this is the name set in the <i>[[VirtOODBCEDM][Creating EDM in Visual Studio 2008]]</i> section) as the <b><nop>DataService</b> name. Enable access to the Data Service by adding the entry <b><code><nowiki>config.SetEntitySetAccessRule("*", EntitySetRights.All);</nowiki></code></b> to the <b><code><nowiki>InitializeService</nowiki></code></b> method. <verbatim> // C# using System; using System.Web; using System.Collections.Generic; using System.ServiceModel.Web; using System.Linq; using System.Data.Services; namespace SimpleDataService { public class Northwind : DataService<VirtuosoDemoEntities> { public static void InitializeService(IDataServiceConfiguration config) { config.SetEntitySetAccessRule("*", EntitySetRights.All); } } } </verbatim> %BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataServices_16.png" style="wikiautogen"/>%BR%%BR% 1 To test the Data Service, simply hit <b>Ctrl+F5</b> within Visual Studio. This will start the development web server, run the Data Services server inside, and load a Web browser page displaying the list of available tables/entities for the Microsoft Access Northwind database catalog. %BR%%BR%<img src="%ATTACHURLPATH%/VirtEntityFrameworkOODBCDatService1.png" style="wikiautogen"/>%BR%%BR% 1 To access a specific entity instance like the Customers table ALFKI record, use this convention: <b><code><nowiki>http://host/vdir/Virtuoso.svc/Customers('ALFKI')</nowiki></code></b> . %BR%%BR%<img src="%ATTACHURLPATH%/VirtEntityFrameworkOODBCDatService2.png" style="wikiautogen"/>%BR%%BR% ---+++NOTES 1 <b>Important</b> - To view <b>Atom</b> (the default format returned by an ADO.NET Data Service) in Internet Explorer, you must first ensure that <b>Feed Reading View</b> is turned <b>off</b>. This can be done on the <b>Content tab</b> of <b>Tools<b> in <b>Internet Options</b>.%BR%%BR% 1 If a Data Services entity instance URI page fails to load, you can turn <b>Verbose</b> errors on by adding <b><code><nowiki>config.UseVerboseErrors = true;</nowiki></code></b> in the <b><code><nowiki>virtuoso.svc.cs InitializeService</nowiki></code></b> method to obtain more detailed information from the server as to why the page failed to load: <verbatim> public static void InitializeService(IDataServiceConfiguration config) { config.UseVerboseErrors = true; config.SetEntitySetAccessRule("*", EntitySetRights.All); } </verbatim> CategoryDocumentation CategoryVirtuoso CategoryEntityFramework CategoryDotNET CategoryODBC CategoryODBCODBCBridge

sioc:id

f4e059fb79449b2726e554bfb8b5a7de

sioc:link

n2:VirtEntityFrameworkOODBCDatService

sioc:has_container

n10:VOS

n5:has_services

n6:item

atom:title

VirtEntityFrameworkOODBCDatService

sioc:links_to

n2:CategoryODBCODBCBridge n2:CategoryODBC n2:CategoryDotNET n13:CategoryEntityFramework n2:CategoryVirtuoso n2:CategoryDocumentation

atom:source

n10:VOS

atom:author

n16:this

atom:published

2017-06-13T05:48:34Z

atom:updated

2017-06-29T07:37:12Z

sioc:topic

n10:VOS

Subject Item

n2:VirtODBCEntityFrameworkUsage

sioc:links_to

n2:VirtEntityFrameworkOODBCDatService