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

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

Namespace Prefixes

PrefixIRI
dctermshttp://purl.org/dc/terms/
atomhttp://atomowl.org/ontologies/atomrdf#
foafhttp://xmlns.com/foaf/0.1/
n13http://vos.openlinksw.com/dataspace/services/wiki/
oplhttp://www.openlinksw.com/schema/attribution#
n2http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
dchttp://purl.org/dc/elements/1.1/
n11http://vos.openlinksw.com/dataspace/dav#
n7http://vos.openlinksw.com:80/wiki/main/VOS/VirtMySQLEDM/
rdfshttp://www.w3.org/2000/01/rdf-schema#
n12http://rdfs.org/sioc/services#
siocthttp://rdfs.org/sioc/types#
n15http://vos.openlinksw.com/dataspace/person/dav#
n8http://vos.openlinksw.com/dataspace/owiki/wiki/
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n6http://vos.openlinksw.com/wiki/main/VOS/VirtMySQLEDM/
n10http://vos.openlinksw.com/dataspace/owiki#
n4http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtMySQLEDM/
xsdhhttp://www.w3.org/2001/XMLSchema#
n19http://vos.openlinksw.com/dataspace/person/owiki#
siochttp://rdfs.org/sioc/ns#

Statements

Subject Item
n15:this
foaf:made
n2:VirtMySQLEDM
Subject Item
n11:this
sioc:creator_of
n2:VirtMySQLEDM
Subject Item
n13:item
n12:services_of
n2:VirtMySQLEDM
Subject Item
n10:this
sioc:creator_of
n2:VirtMySQLEDM
Subject Item
n8:VOS
sioc:container_of
n2:VirtMySQLEDM
atom:entry
n2:VirtMySQLEDM
atom:contains
n2:VirtMySQLEDM
Subject Item
n2:VirtMySQLEntityFrameworkUsage
sioc:links_to
n2:VirtMySQLEDM
Subject Item
n2:VirtMySQLEDM
rdf:type
atom:Entry sioct:Comment
dcterms:created
2017-06-13T05:47:46.329661
dcterms:modified
2017-06-29T07:38:40.501380
rdfs:label
VirtMySQLEDM
foaf:maker
n19:this n15:this
dc:title
VirtMySQLEDM
opl:isDescribedUsing
n4:sioc.rdf
sioc:has_creator
n10:this n11:this
sioc:attachment
n6:VirtAdoNetDataServices_2.png n6:VirtAdoNetDataServices_3.png n6:VirtAdoNetDataServices_1.png n6:VirtAdoNetDataServices_14.png n7:._VirtAdoNetDataServices_14.png n6:VirtAdoNetDataServices_6.png n6:VirtEDM1.png n7:._VirtAdoNetAddConn.png n6:VirtAdoNetDataServices_4.png n7:._VirtAdoNetDataServices_1.png n6:VirtAdoNetDataServices_5.png n6:._VirtMySQLEDM5_1.png n6:._VirtMySQLEDM6.png n6:._VirtMySQLEDM3.png n6:._VirtMySQLEDM4.png n6:._VirtOracleEDM5_1.png n6:VirtAdoNetAddConn.png n6:._VirtOracleEDM4.png n6:._VirtOracleEDM5.png n6:._VirtEDM3.png n6:._VirtEDM5.png n6:._VirtEDM1.png n6:._VirtEDM2.png n6:._VirtMySQLEDM1.png n6:._VirtMySQLEDM2.png n6:._VirtIngresEDM4.png n6:._VirtIngresEDM5_1.png n6:._VirtAdoNetDataServices_14.png n6:._VirtAdoNetDataServices_2.png n6:._VirtAdoNetAddConn.png n6:._VirtAdoNetDataServices_1.png n6:._VirtAdoNetDataServices_5.png n6:._VirtAdoNetDataServices_6.png n6:._VirtAdoNetDataServices_3.png n6:._VirtAdoNetDataServices_4.png n7:._VirtMySQLEDM2.png n7:._VirtMySQLEDM1.png n6:VirtOracleEDM5.png n7:._VirtMySQLEDM5_1.png n6:VirtOracleEDM5_1.png n7:._VirtMySQLEDM3.png n7:._VirtMySQLEDM4.png n6:VirtMySQLEDM2.png n7:._VirtOracleEDM4.png n6:VirtMySQLEDM3.png n7:._VirtOracleEDM5.png n6:VirtMYSEDM5.png n6:VirtMySQLEDM1.png n7:._VirtMySQLEDM6.png n7:._VirtIngresEDM5_1.png.9zpAAi n6:VirtMySQLEDM6.png n6:VirtOracleEDM4.png n7:._VirtEDM5.png.qzI0j8 n6:VirtMySQLEDM4.png n7:._VirtIngresEDM4.png.L3wkhc n6:VirtMySQLEDM5_1.png n6:VirtEDM5.png n6:VirtIngresEDM4.png n6:VirtEDM2.png n7:._VirtMySQLEDM1.png.K1O0Ls n6:VirtEDM3.png n6:VirtMYSEDM2.png n7:._VirtAdoNetDataServices_4.png.I0prYj n6:VirtMYSEDM3.png n7:._VirtAdoNetDataServices_5.png.deY1aG n6:VirtIngresEDM5_1.png n7:._VirtOracleEDM5_1.png n7:._VirtAdoNetDataServices_2.png.pV8NLV n6:VirtMYSEDM1.png n7:._VirtAdoNetDataServices_3.png.AGXWi4 n7:._VirtEDM2.png.TydQSo n7:._VirtAdoNetDataServices_3.png n7:._VirtEDM3.png.QWustc n7:._VirtAdoNetDataServices_4.png n7:._VirtAdoNetDataServices_6.png.kUnDw7 n7:._VirtEDM1.png.JFBS9G n7:._VirtAdoNetDataServices_2.png n7:._VirtAdoNetDataServices_6.png n7:._VirtAdoNetDataServices_1.png.fnkgkU n7:._VirtAdoNetDataServices_14.png.5guR2R n7:._.DS_Store.Iq9mvi n7:._VirtAdoNetAddConn.png.Bqgyc3 n7:._VirtAdoNetDataServices_5.png n7:.DS_Store n7:._VirtEDM3.png n7:._VirtEDM1.png n7:._VirtEDM2.png n7:._VirtIngresEDM4.png n7:._VirtIngresEDM5_1.png n7:._VirtEDM5.png n7:._VirtOracleEDM5.png.0IuQtp n7:._VirtOracleEDM5_1.png.1V5YCf n6:.DS_Store n6:._.DS_Store n7:._VirtMySQLEDM4.png.FSfPMe n7:._VirtMySQLEDM3.png.85LwOV n7:._VirtMySQLEDM6.png.Agbjx4 n7:._VirtOracleEDM4.png.zSZ26H n7:._VirtMySQLEDM5_1.png.meER8z n7:._VirtMySQLEDM2.png.ZEsRhF n7:._.DS_Store
sioc:content
%VOSWARNING% %META:TOPICPARENT{name="VirtMySQLEntityFrameworkUsage"}% ---+++Creating an Entity Data Model (EDM) for the <nop>MySQL Northwind database The following steps can be used to create an Entity Data Model (EDM) for the <nop>MySQL Northwind database: 1 Launch the Visual Studio 2008 SP1 IDE. %BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataServices_1.png" style="wikiautogen"/>%BR%%BR% 1 Create a <b>Web Application</b> project by going to the <b>File</b> menu in Visual Studio and choosing <b>New Project</b>. %BR%%BR% 1 When the New Project window appears, choose either <b>Visual Basic</b> or <b>Visual C#</b> as your programming language.%BR%%BR% 1 Within the language category, click on <b>Web</b> and select <b>ASP.NET Web Application</b> from the right-hand panel. %BR%%BR% 1 Choose a name for the project, for example <b><nop>VirtuosoDataService</b>, and click <b>OK</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataServices_2.png" style="wikiautogen"/>%BR%%BR% 1 This will create a new project called <b><nop>VirtuosoDataService</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataServices_3.png" style="wikiautogen"/>%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 Entity Data Model</b> template. Give it the name <b>Virtuoso.edmx</b> and click <b>Add</b> to start the creation of the ADO.Net Entity Data Model. %BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataServices_5.png" style="wikiautogen"/>%BR%%BR% 1 In the <b>Entity Data Model Wizard</b> dialog <b>Choose Model Contents</b> page, select the <b>Generate from Database</b> model type and click <b>Next</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataServices_6.png" style="wikiautogen"/>%BR%%BR% 1 In the <b>Entity Data Model Wizard</b> dialog <b>Choose your Data Connection</b> page, select the <b>New Connection</b> button. %BR%%BR%<img src="%ATTACHURLPATH%/VirtEDM1.png" style="wikiautogen"/>%BR%%BR% 1 In the <b>Choose Data Source</b> dialog, select the <b><nop>OpenLink Virtuoso Data Source</b> from the list and click <b>Continue</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtEDM2.png" style="wikiautogen"/>%BR%%BR% 1 In the <b>Add Connection</b> dialog, specify the <b>hostname</b>, <b>portno</b>, <b>username</b>, and <b>password</b> for the target Virtuoso Server and and check the <b>Save Password</b> check box. %BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetAddConn.png" style="wikiautogen"/>%BR%%BR% 1 Select the <b>Select Database From List</b> radio button and choose the <b>mysql</b> database from the drop down list. %BR%%BR%<img src="%ATTACHURLPATH%/VirtMySQLEDM4.png" style="wikiautogen"/>%BR%%BR% 1 Press the <b>Test Connection</b> dialog to verify the database is accessible. %BR%%BR%<img src="%ATTACHURLPATH%/VirtEDM5.png" style="wikiautogen"/>%BR%%BR% 1 Click <b>OK</b> to add the connection.%BR% %BR%%BR%<img src="%ATTACHURLPATH%/VirtMySQLEDM5_1.png" style="wikiautogen"/>%BR%%BR% 1 Set the <b>entity connect string</b> name to <b><nop>VirtuosoEntities</b> (note this name as it is required in the section on creating and ADO.Net Data Service) and click <b>Next</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtMySQLEDM2.png" style="wikiautogen"/>%BR%%BR% 1 In the <b>Choose your Database Objects</b> page, tick the <b>Tables</b> check box to select all tables in the mysql catalog for addition to the Enity Data Model. Set the <b>Model Namespace</b> to <b><nop>VirtuosoModel</b> and click <b>Finish</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtMySQLEDM3.png" style="wikiautogen"/>%BR%%BR% 1 The <b>Virtuoso.edmx</b> EDM will be created with the tables and relationships displayed in the Visual Studio IDE. %BR%%BR%<img src="%ATTACHURLPATH%/VirtMySQLEDM6.png" style="wikiautogen"/>%BR%%BR% Creation for the Entity Data Model for the <nop>MySQL Northwind database is now complete.
sioc:id
45c832f3f90edeef1b5453c672de5da9
sioc:link
n2:VirtMySQLEDM
sioc:has_container
n8:VOS
n12:has_services
n13:item
atom:title
VirtMySQLEDM
atom:source
n8:VOS
atom:author
n15:this
atom:published
2017-06-13T05:47:46Z
atom:updated
2017-06-29T07:38:40Z
sioc:topic
n8:VOS