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

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

Subject Item

n17:this

foaf:made

n4:VirtEntityFrameworkSQLDatService

Subject Item

n5:this

sioc:creator_of

n4:VirtEntityFrameworkSQLDatService

Subject Item

n6:item

n7:services_of

n4:VirtEntityFrameworkSQLDatService

Subject Item

n9:this

sioc:creator_of

n4:VirtEntityFrameworkSQLDatService

Subject Item

n2:VOS

sioc:container_of

n4:VirtEntityFrameworkSQLDatService

atom:entry

n4:VirtEntityFrameworkSQLDatService

atom:contains

n4:VirtEntityFrameworkSQLDatService

Subject Item

n4:VirtEntityFrameworkSQLDatService

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T05:41:37.745197

dcterms:modified

2017-06-13T05:41:37.745197

rdfs:label

VirtEntityFrameworkSQLDatService

foaf:maker

n17:this n24:this

dc:title

VirtEntityFrameworkSQLDatService

opl:isDescribedUsing

n22:rdf

sioc:has_creator

n5:this n9:this

sioc:attachment

n10:png n11:png n14:png n15:png n18:png

sioc:content

%META:TOPICPARENT{name="VirtMSSQLServerEntityFrameworkUsage"}% ---+++Creating an ADO.Net Data Service An ADO.Net Data Service for the SQL Server tables can be created using the Entity Data Model created in the [[VirtSQLEDM][Creating EDM in Visual Studio 2008]] section. 1. Open the <b><nop>VirtuosoDataService</b> project created in the [[VirtSQLEDM][Creating EDM in Visual Studio 2008]] section.%BR%%BR% 2. 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% 3. 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% 4. 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> to 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% 5. 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 Northwind Demo database catalog. %BR%%BR%<img src="%ATTACHURLPATH%/VirtEntityFrameworkSQLDatService1.png" style="wikiautogen"/>%BR%%BR% 6. To access a specific entity instance like the Customers table ALFKI record, use this convention: http://host/vdir/Virtuoso.svc/Customers('ALFKI') </b> . %BR%%BR%<img src="%ATTACHURLPATH%/VirtEntityFrameworkSQLDatService2.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% 2. 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 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

d69acad331e1bf995783feb02b881d53

sioc:link

n4:VirtEntityFrameworkSQLDatService

sioc:has_container

n2:VOS

n7:has_services

n6:item

atom:title

VirtEntityFrameworkSQLDatService

sioc:links_to

n23:

atom:source

n2:VOS

atom:author

n17:this

atom:published

2017-06-13T05:41:37Z

atom:updated

2017-06-13T05:41:37Z

sioc:topic

n2:VOS