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.

Subject Item

n58:this

foaf:made

n2:VirtMySQLEDM

Subject Item

n23:this

sioc:creator_of

n2:VirtMySQLEDM

Subject Item

n42:item

n41:services_of

n2:VirtMySQLEDM

Subject Item

n19:this

sioc:creator_of

n2:VirtMySQLEDM

Subject Item

n15: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

n116:this n58:this

dc:title

VirtMySQLEDM

opl:isDescribedUsing

n4:rdf

sioc:has_creator

n19:this n23:this

sioc:attachment

n6:png n7:png n8:png n9:png n10:png n11:png n12:png n13:png n14:png n16:png n18:png n20:png n21:png n22:png n24:png n25:png n26:png n27:png n28:png n29:png n30:png n31:png n32:png n33:png n34:png n35:png n36:png n37:png n38:png n39:png n40:png n44:png n45:png n46:png n47:png n48:png n49:png n50:png n51:png n52:png n53:png n54:png n55:png n56:png n57:png n59:png n60:png n61:png n62:png n63:9zpAAi n64:png n65:png n66:qzI0j8 n67:png n68:L3wkhc n69:png n70:png n71:png n72:png n73:K1O0Ls n74:png n75:png n76:I0prYj n77:png n78:deY1aG n79:png n80:png n81:pV8NLV n82:png n83:AGXWi4 n84:TydQSo n86:png n87:QWustc n88:png n89:kUnDw7 n90:JFBS9G n91:png n93:png n94:fnkgkU n95:5guR2R n96:Iq9mvi n97:Bqgyc3 n98:png n99:DS_Store n100:png n102:png n103:png n104:png n105:png n106:png n107:0IuQtp n108:1V5YCf n109:DS_Store n110:DS_Store n111:FSfPMe n112:85LwOV n113:Agbjx4 n114:zSZ26H n115:meER8z n117:ZEsRhF n119: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

n15:VOS

n41:has_services

n42:item

atom:title

VirtMySQLEDM

atom:source

n15:VOS

atom:author

n58:this

atom:published

2017-06-13T05:47:46Z

atom:updated

2017-06-29T07:38:40Z

sioc:topic

n15:VOS