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

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

Subject Item

n6:this

foaf:made

n2:VirtEntityFrameworkMySQLDatService

Subject Item

n17:this

sioc:creator_of

n2:VirtEntityFrameworkMySQLDatService

Subject Item

n4:item

n3:services_of

n2:VirtEntityFrameworkMySQLDatService

Subject Item

n14:this

sioc:creator_of

n2:VirtEntityFrameworkMySQLDatService

Subject Item

n11:VOS

sioc:container_of

n2:VirtEntityFrameworkMySQLDatService

atom:entry

n2:VirtEntityFrameworkMySQLDatService

atom:contains

n2:VirtEntityFrameworkMySQLDatService

Subject Item

n2:VirtMySQLEntityFrameworkUsage

sioc:links_to

n2:VirtEntityFrameworkMySQLDatService

Subject Item

n2:VirtEntityFrameworkMySQLDatService

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T05:49:06.395332

dcterms:modified

2017-06-13T05:49:06.395332

rdfs:label

VirtEntityFrameworkMySQLDatService

foaf:maker

n6:this n39:this

dc:title

VirtEntityFrameworkMySQLDatService

opl:isDescribedUsing

n22:rdf

sioc:has_creator

n14:this n17:this

sioc:attachment

n12:DS_Store n15:png n16:png n18:png n19:png n20:png n23:bTSpZy n24:png n25:png n26:6hOReX n27:mq7H4g n28:png n29:png n30:1Prqf2 n31:png n32:png n33:DS_Store n34:Kkv6zT n35:png n36:png n37:luDhUQ n38:DS_Store n40:png n42:gOZ7uU n43:DS_Store

sioc:content

%VOSWARNING% %META:TOPICPARENT{name="VirtMySQLEntityFrameworkUsage"}% ---+++Creating an ADO.Net Data Service An ADO.Net Data Service for the <nop>MySQL tables can be created using the Entity Data Model created in the [[VirtMySQLEDM][Creating EDM in Visual Studio 2008]] section. 1 Open the <b><nop>VirtuosoDataService</b> project created in the [[VirtMySQLEDM][Creating EDM in Visual Studio 2008]] 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>Virtuoso.svc</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>Virtuoso.svc.cs</b> Data Service file, add the data source class name of <b><nop>VirtuosoEntities</b> (note this is the name set in the Creating EDM in Visual Studio 2008 section) as the <b><nop>DataService</b> name. Enable access to the Data Service by adding the entry <b>config.SetEntitySetAccessRule("*", EntitySetRights.All);</b> in the <b><nop>InitializeService</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 tables/entities for the Northwind database catalog. %BR%%BR%<img src="%ATTACHURLPATH%/VirtEntityFrameworkMySQLDatService1.png" style="wikiautogen"/>%BR%%BR% 1 To access a specific entity instance like the Customers table ALFKI record, use this convention <b>http://host/vdir/Virtuoso.svc/Customers('ALFKI') </b> . %BR%%BR%<img src="%ATTACHURLPATH%/VirtEntityFrameworkMySQLDatService2.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>config.UseVerboseErrors = true;</b> in the <b>virtuoso.svc.cs <nop>InitializeService </b> method. This allows you 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>

sioc:id

faeaf162494079565fe6508e450725a9

sioc:link

n2:VirtEntityFrameworkMySQLDatService

sioc:has_container

n11:VOS

n3:has_services

n4:item

atom:title

VirtEntityFrameworkMySQLDatService

sioc:links_to

n13:

atom:source

n11:VOS

atom:author

n6:this

atom:published

2017-06-13T05:49:06Z

atom:updated

2017-06-13T05:49:06Z

sioc:topic

n11:VOS