HTML Microdata document

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.

Namespace Prefixes

Prefix	IRI
dcterms	http://purl.org/dc/terms/
atom	http://atomowl.org/ontologies/atomrdf#
n16	http://docs.openlinksw.com/virtuoso/rdfsparqlintegrationmiddleware.html#
foaf	http://xmlns.com/foaf/0.1/
n21	http://vos.openlinksw.com/dataspace/services/wiki/
n7	http://virtuoso.openlinksw.com/Whitepapers/html/vdld_html/VirtDeployingLinkedDataGuide_Glossary.html#
opl	http://www.openlinksw.com/schema/attribution#
n14	http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtSPASQLWebDataServiceApp/
n2	http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
dc	http://purl.org/dc/elements/1.1/
n12	http://vos.openlinksw.com/dataspace/dav#
rdfs	http://www.w3.org/2000/01/rdf-schema#
n20	http://rdfs.org/sioc/services#
sioct	http://rdfs.org/sioc/types#
n10	http://vos.openlinksw.com/dataspace/person/dav#
n11	http://vos.openlinksw.com/dataspace/owiki/wiki/
rdf	http://www.w3.org/1999/02/22-rdf-syntax-ns#
n15	http://vos.openlinksw.com/wiki/main/VOS/VirtSPASQLWebDataServiceApp/
n18	http://vos.openlinksw.com/dataspace/owiki#
xsdh	http://www.w3.org/2001/XMLSchema#
n17	http://vos.openlinksw.com/dataspace/person/owiki#
sioc	http://rdfs.org/sioc/ns#
n23	http://docs.openlinksw.com/virtuoso/rdfdatarepresentation.html#
n6	http://s3.amazonaws.com/opldownload/uda/vad-packages/6.1/virtuoso/

Statements

Subject Item: n2:VirtSPASQLWebDataServiceApp
rdf:type: atom:Entry sioct:Comment
dcterms:created: 2017-06-13T05:40:57.386082
dcterms:modified: 2017-06-13T05:40:57.386082
rdfs:label: VirtSPASQLWebDataServiceApp
foaf:maker: n10:this n17:this
dc:title: VirtSPASQLWebDataServiceApp
opl:isDescribedUsing: n14:sioc.rdf
sioc:has_creator: n12:this n18:this
sioc:attachment: n15:isql.png n15:sparqlview.png n15:description.png n15:firefox.png n15:RDFWebApp.png n15:RDFWebDemo.png n15:DefaultPage.png n15:Description.png n15:.DS_Store
sioc:content: %META:TOPICPARENT{name="VirtAdoNet35Provider"}% ---+ Creating a Web Browser Application to Access RDF Data Using The Virtuoso ADO.NET Provider %TOC% ---++ Introduction This document will guide you through creating first a Web Service that exposes RDF data from Virtuoso and then a simple web browser application that consumes the Web Service and allowing you to access and explore the RDF data by clicking on dereferenceable [[http://docs.openlinksw.com/virtuoso/rdfdatarepresentation.html#rdfiriidtype][IRIs]]. ---++ Prerequisites 1 Microsoft Visual Studio 2008 1 The Virtuoso ADO.NET provider for .NET 3.5 and the Entity Framework 1 The Virtuoso [[http://s3.amazonaws.com/opldownload/uda/vad-packages/6.1/virtuoso/cartridges_dav.vad][Cartridges VAD package]] 1 The example assumes that you have a local Virtuoso server with the Northwind demo database installed. If the demo database is not already installed then download the [[http://s3.amazonaws.com/opldownload/uda/vad-packages/6.1/virtuoso/demo_dav.vad][demo database VAD package]] (<code>demo_dav.vad</code>) and install it. The VAD package will create a new database in Virtuoso called demo containing the familiar Northwind tables. It will also create [[http://docs.openlinksw.com/virtuoso/rdfsparqlintegrationmiddleware.html#rdfviews][Linked Data Views]] of the Northwind tables. In the example we assume the database is accessible on a hostname of "<code>demo.openlinksw.com</code>" on the default port <code>80</code>, where an actually live instance of the Virtuoso Demo database is hosted. Users would use the appropriate hostname and port number of their Virtuoso installation to create the sample application, and would be would be <code>localhost:8890</code> for a default installation or whatever the <code>URIQA <nowiki>DefaultHost</nowiki></code> Virtuoso configuration parameter is set to when the demo database VAD package is installed. ---++ Creating the Web Service ---+++ Step 1 - Create a view of the RDF data To create a view of the customers in the Northwind first open the Virtuoso Conductor and log in as <code>dba</code>. Then open <nowiki>iSQL</nowiki> from the menu on the left and execute the following statement. <verbatim> CREATE VIEW Demo.demo.sparqlview AS SPARQL PREFIX nwind: <http://demo.openlinksw.com/schemas/northwind#> SELECT DISTINCT ?s FROM <http://demo.openlinksw.com/Northwind> WHERE { ?s a nwind:Customer } </verbatim> *Note*: * If the view is added to the Visual Studio project as user "<code>demo</code>" (or any other than "<code>dba</code>'), then it must be ensured that the "<code>SPARQL_SELECT</code>" and "<code>SPARQL_SPONGE</code>" roles are assigned to this user, which can be done via the Virtuoso Conductor in the System Admin -> User Accounts tab. * Execute permissions will also need to be granted to the RDF_MAKE_LONG_OF_SQLVAL procedure, with an iSQL statement similar to the following: <verbatim> GRANT EXECUTE ON DB.DBA.RDF_MAKE_LONG_OF_SQLVAL TO "demo" </verbatim> %BR%%BR%<img src="%ATTACHURLPATH%/isql.png" style="wikiautogen"/>%BR%%BR% ---+++ Step 2 - Create the Visual Studio Project and Add the Model 1 Open Visual Studio and create a new ASP .NET Web Application called <code>><nowiki>RDFWebDemo</nowiki></code>. %BR%%BR%<img src="%ATTACHURLPATH%/RDFWebDemo.png" style="wikiautogen"/>%BR%%BR% 1 Right-click <nowiki>RDFWebDemo</nowiki> in the Solution Explorer, and add a new <nowiki>ADO.NET Entity Data Model</nowiki> called <code>Model1.edmx</code>. This will open the Entity Data Model Wizard. 1 Choose Generate From Database and click Next. 1 Set up a connection to the Demo database on your local Virtuoso Server, select Yes, include the sensitive data in the connection string and set the name of the entities to <code><nowiki>DemoEntities</nowiki></code>. Click Next. 1 On the Choose Your Database Objects page expand Views and select <code>sparqlview</code>. Check that the Model Namespace is <nowiki>DemoModel</nowiki> and click Finish. %BR%%BR%<img src="%ATTACHURLPATH%/sparqlview.png" style="wikiautogen"/>%BR%%BR% ---+++ Step 3 - Add the Web Service 1 Right click <nowiki>RDFWebDemo</nowiki> in the Solution Explorer and add a new <nowiki>ADO.NET Data Service</nowiki> called <code>WebDataService1.svc</code>. Click Add. 1 In the class definition of <nowiki>WebDataService1</nowiki> in the newly created file <code><nowiki>WebDataService1.svc.cs</nowiki></code> replace "<code>/* TODO: put your data source class name here */</code>" with the name of our model, <code><nowiki>DemoEntities</nowiki></code>. <verbatim> public class WebDataService1 : DataService<DemoEntities> </verbatim> 1 In the <nowiki>InitializeService</nowiki> method, add the line: <verbatim> config.SetEntitySetAccessRule("*", EntitySetRights.All); </verbatim> The method should look like this <verbatim> public static void InitializeService(IDataServiceConfiguration config) { // TODO: set rules to indicate which entity sets and service operations are visible, updatable, etc. // Examples: // config.SetEntitySetAccessRule("MyEntityset", EntitySetRights.AllRead); // config.SetServiceOperationAccessRule("MyServiceOperation", ServiceOperationRights.All); config.SetEntitySetAccessRule("*", EntitySetRights.All); } </verbatim> ---+++ Step 4 - Compile and Run Hit F5 to compile and run the service. Click OK when prompted to enable debugging. The default browser will be launched showing a page like -- <verbatim> <?xml version="1.0" encoding="utf-8" standalone="yes" ?> - <service xml:base="http://localhost:1241/WebDataService1.svc/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:app="http://www.w3.org/2007/app" xmlns="http://www.w3.org/2007/app"> - <workspace> <atom:title>Default</atom:title> - <collection href="sparqlview"> <atom:title>sparqlview</atom:title> </collection> </workspace> </service> </verbatim> The service is now running. Note the address on which the service is made available. You will need to know this when creating the app to consume the service. Look in the Address Bar of the browser. It will be something like: <code><nowiki>http://localhost:1492/WebDataService1.svc/</nowiki></code> ---++ Creating the Browser Application ---+++ Step 1 - Create the Visual Studio Project 1 Open Visual Studio and create a new ASP.NET Web Application called <code><nowiki>RDFWebApp</nowiki></code>. %BR%%BR%<img src="%ATTACHURLPATH%/RDFWebApp.png" style="wikiautogen"/>%BR%%BR% 1 Create client side entities with <code>datasvcutil.exe</code>. 1 Open a command prompt. 1 Navigate to <code><nowiki>C:\WINDOWS\Microsoft.NET\Framework\v3.5</nowiki></code>. 1 Generate the client classes using the following command: <verbatim> datasvcutil.exe /uri:http://localhost:1492/WebDataService1.svc /out:DemoEntities.cs </verbatim> Note the address of the service. You may need to change the port number to match the one seen in the address at the end of Step 4 in Creating the Web Service. 1 Add the classes to <nowiki>RDFWebApp</nowiki>. 1 Right click <nowiki>RDFWebApp</nowiki>. 1 Choose to add an existing item and add <code><nowiki>c:\WINDOWS\Microsoft.NET\Framework\v3.5\DemoEntities.cs</nowiki></code>. 1 Add a reference to <code>System.Data.Services.Client</code> to the project. ---+++ Step 2 - Display the contents of sparqlview as a table on the page To display the RDF data on the web page, we create a table with a row for each item in sparqlview. We then use each IRI from sparqlview to create a hyperlink. The hyperlinks are displayed in the table cells. To do this, add the following block of code to the <code>page_load</code> method in <code>Default.aspx.cs</code>. <verbatim> DemoModel.DemoEntities svc = new DemoModel.DemoEntities(new Uri("http://localhost:1492/WebDataService1.svc")); var query = svc.sparqlview; Table iriTable = new Table(); this.Controls.Add(iriTable); foreach (DemoModel.sparqlview sv in query) { TableRow tRow = new TableRow(); iriTable.Rows.Add(tRow); TableCell tCell = new TableCell(); tRow.Cells.Add(tCell); HyperLink h = new HyperLink(); h.Text = sv.s; h.NavigateUrl = sv.s; tCell.Controls.Add(h); } </verbatim> Note the address of the service in the first line. You may need to change the port number to match the one seen in the address at the end of Step 4 in Creating the Web Service. Compile and run <nowiki>RDFWebApp</nowiki> (ensuring that the service created above is still running). This will launch a browser and display the IRIs from sparqlview as a list of hyperlinks. %BR%%BR%<img src="%ATTACHURLPATH%/DefaultPage.png" style="wikiautogen"/>%BR%%BR% With the [[http://s3.amazonaws.com/opldownload/uda/vad-packages/6.1/virtuoso/cartridges_dav.vad][Cartridges VAD package]] installed in Virtuoso, clicking on these links will take you to a description page of the referenced resource. The description page is created using <code>[[http://virtuoso.openlinksw.com/Whitepapers/html/vdld_html/VirtDeployingLinkedDataGuide_Glossary.html#mozTocId13075][description.vsp]]</code>. %BR%%BR%<img src="%ATTACHURLPATH%/Description.png" style="wikiautogen"/>%BR%%BR% ---++ Deploy With IIS We have used the Visual Studio Development Server to create and test this simple Web Service. This section describes how to deploy the service using IIS. ---+++ Web Service To deploy the service using IIS: 1 Open the <nowiki>RDFWebDemo</nowiki> project in Visual Studio, go to the Project menu and select <nowiki>RDFWebDemo</nowiki> Properties. 1 Select the Web tab and scroll down to the Servers section. Select Use local IIS Server. The project URL defaults to using localhost. 1 Click the Create Virtual Directory button then check that the Service works on localhost. 1 Build the project; then start without debugging (ctrl-F5). The start page that you see when you test the service will look the same as before but the address in the browser bar will be something like <code><nowiki>http://localhost/RDFWebDemo1/WebDataService1.svc/</nowiki></code>. You can now access your service remotely using the hostname or IP address of your server. If at this point you get an Access is denied error, 401.3, then you will need to add the Internet Guest Account (<code>IUSR_XXX</code> where <code>XXX</code> is your computer name) to the users allowed to access the folder containing the <nowiki>RDFWebDemo</nowiki> project. ---+++ Web Application You will now need to modify <nowiki>RDFWebApp</nowiki> to access the service at the new address. At the same time we will also change <nowiki>RDFWebApp</nowiki> so that it too is deployed using IIS 1 Open The <nowiki>RDFWebApp</nowiki> project in Visual Studio. 1 Go to the Project menu and select <nowiki>RDFWebApp</nowiki> Properties. 1 Select the Web tab and scroll down to the Servers section. Select Use local IIS Server. The project URL defaults to using localhost. 1 Click the Create Virtual Directory button. The web application will then run on the local IIS. 1 To reference the web service running on IIS you will need to edit <code>Default.aspx.cs</code>. Change <verbatim> DemoModel.DemoEntities svc = new DemoModel.DemoEntities(new Uri("http://localhost:1492/WebDataService1.svc")); </verbatim> to <verbatim> DemoModel.DemoEntities svc = new DemoModel.DemoEntities(new Uri("http://localhost/RDFWebDemo/WebDataService1.svc/")); </verbatim> 1 Build the project then start without debugging (ctrl-F5). The web application is accessible on <code><nowiki>http://localhost/RDFWebApp/Default.aspx</nowiki></code> and can also be accessed using the hostname or IP address of your server, e.g., <code><nowiki>http://192.168.7.129/RDFWebApp/Default.aspx</nowiki></code> %BR%%BR%<img src="%ATTACHURLPATH%/firefox.png" style="wikiautogen"/>%BR%%BR% ---++ Next Steps This example showed you how to quickly create an ADO.NET Data Service that exposes RDF data in Virtuoso and how to create a basic Web application to consume that service. The next step is to create a Silverlight Application to consume the same service. * [[VirtSPASQLSilverLightApp][Creating a Silverlight Application to consume the service]]
sioc:id: 8736e83a5ee7cf82c5756705607465dc
sioc:link: n2:VirtSPASQLWebDataServiceApp
sioc:has_container: n11:VOS
n20:has_services: n21:item
atom:title: VirtSPASQLWebDataServiceApp
sioc:links_to: n2:VirtSPASQLSilverLightApp n6:cartridges_dav.vad n7:mozTocId13075 n6:demo_dav.vad n16:rdfviews n23:rdfiriidtype
atom:source: n11:VOS
atom:author: n10:this
atom:published: 2017-06-13T05:40:57Z
atom:updated: 2017-06-13T05:40:57Z
sioc:topic: n11:VOS