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

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

Subject Item

n8:this

foaf:made

n4:VirtEntityFrameworkPGRDatService

Subject Item

n13:this

sioc:creator_of

n4:VirtEntityFrameworkPGRDatService

Subject Item

n23:item

n22:services_of

n4:VirtEntityFrameworkPGRDatService

Subject Item

n2:this

sioc:creator_of

n4:VirtEntityFrameworkPGRDatService

Subject Item

n11:VOS

sioc:container_of

n4:VirtEntityFrameworkPGRDatService

atom:entry

n4:VirtEntityFrameworkPGRDatService

atom:contains

n4:VirtEntityFrameworkPGRDatService

Subject Item

n4:VirtEntityFrameworkPGRDatService

rdf:type

atom:Entry sioct:Comment

dcterms:created

2017-06-13T05:41:13.855810

dcterms:modified

2017-06-13T05:41:13.855810

rdfs:label

VirtEntityFrameworkPGRDatService

foaf:maker

n8:this n25:this

dc:title

VirtEntityFrameworkPGRDatService

opl:isDescribedUsing

n20:rdf

sioc:has_creator

n13:this n2:this

sioc:attachment

n12:png n14:png n15:png n16:png n17:png

sioc:content

%META:TOPICPARENT{name="VirtPostgresEntityFrameworkUsage"}% ---+++Creating an ADO.Net Data Service An ADO.Net Data Service for the <nop>PostgreSQL tables can be created using the Entity Data Model created in the [[VirtPGREDM][Creating EDM in Visual Studio 2008]] section. 1. Open the <b><nop>VirtuosoDataService</b> project created in the [[VirtPGREDM][Creating EDM in Visual Studio 2008]] section.%BR%%BR% 2. Right click on the <b><nop>VirtuosoDataService</b> project name of 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. Then, enable access to the Data Service by adding the entry <b>config.<nop>SetEntitySetAccessRule("*", <nop>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% 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 in the PGR database catalog. %BR%%BR%<img src="%ATTACHURLPATH%/VirtEntityFrameworkPGRDatService1.png" style="wikiautogen"/>%BR%%BR% 6. To access a specific entity instance like the <b>Customers</b> table customer <b>ALFKI</b> record, use this convention <b>http://host/vdir/Virtuoso.svc/Customers('ALFKI') </b> . %BR%%BR%<img src="%ATTACHURLPATH%/VirtEntityFrameworkPGRDatService2.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.<nop>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

8a55497edb28dd75cbd3daf146c0c96a

sioc:link

n4:VirtEntityFrameworkPGRDatService

sioc:has_container

n11:VOS

n22:has_services

n23:item

atom:title

VirtEntityFrameworkPGRDatService

sioc:links_to

n5: n9:VirtPGREDM

atom:source

n11:VOS

atom:author

n8:this

atom:published

2017-06-13T05:41:13Z

atom:updated

2017-06-13T05:41:13Z

sioc:topic

n11:VOS

Subject Item

n4:VirtPostgresEntityFrameworkUsage

sioc:links_to

n4:VirtEntityFrameworkPGRDatService