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

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

Subject Item

n13:this

foaf:made

n4:VirtSQLEDM

Subject Item

n10:this

sioc:creator_of

n4:VirtSQLEDM

Subject Item

n6:item

n5:services_of

n4:VirtSQLEDM

Subject Item

n12:this

sioc:creator_of

n4:VirtSQLEDM

Subject Item

n2:VOS

sioc:container_of

n4:VirtSQLEDM

atom:entry

n4:VirtSQLEDM

atom:contains

n4:VirtSQLEDM

Subject Item

n4:VirtSQLEDM

rdf:type

atom:Entry sioct:Comment

dcterms:created

2017-06-13T05:40:09.541141

dcterms:modified

2017-06-29T07:40:23.897

rdfs:label

VirtSQLEDM

foaf:maker

n13:this n24:this

dc:title

VirtSQLEDM

opl:isDescribedUsing

n8:rdf

sioc:has_creator

n12:this n10:this

sioc:attachment

n15:png n16:png n17:png n18:png n19:png n20:png n21:png n22:png n26:png n27:png n28:png n30:png n31:png n32:png

sioc:content

%META:TOPICPARENT{name="VirtMSSQLServerEntityFrameworkUsage"}% ---+++Creating an Entity Data Model (EDM) for the Microsoft SQL Server Northwind database The following steps can be used to create an Entity Data Model (EDM) for the Microsoft SQL Server Northwind database: 1. Launch the Visual Studio 2008 SP1 IDE. %BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataServices_1.png" style="wikiautogen"/>%BR%%BR% 2. 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% 3. When the New Project window appears, choose either <b>Visual Basic</b> or <b>Visual C#</b> as the programming language.%BR%%BR% 4. Within the language category click on <b>Web</b>, and select <b>ASP.NET Web Application</b> from the right-hand panel. %BR%%BR% 5. 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% 6. This will create a new project called <b><nop>VirtuosoDataService</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataServices_3.png" style="wikiautogen"/>%BR%%BR% 7. 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% 8. 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% 9. 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% 10. 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%/VirtSQLEDM1.png" style="wikiautogen"/>%BR%%BR% 11. In the <b>Choose Data Source</b> dialog, select the <b><nop>OpenLink Virtuoso Data Source</b> from the list displayed and click <b>Continue</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtSQLEDM2.png" style="wikiautogen"/>%BR%%BR% 12. In the <b>Connection Properties</b> dialog specify the <b>hostname</b>, <b>portno</b>, <b>username</b> and password for the target Virtuoso Server and click the <b>Advanced</b> button. %BR%%BR%<img src="%ATTACHURLPATH%/VirtSQLEDM3.png" style="wikiautogen"/>%BR%%BR% 13. Use the <b>Select Database From List</b> dialog to select the <b>NWIND</b> catalog. %BR%%BR%<img src="%ATTACHURLPATH%/VirtSQLEDM4.png" style="wikiautogen"/>%BR%%BR% 14. Press the <b>Test Connection</b> dialog to verify the database is accessible. Click "OK" to persist the connection attributes, after a successful connection is verified. %BR%%BR%<img src="%ATTACHURLPATH%/VirtSQLEDM5.png" style="wikiautogen"/>%BR%%BR% 15. 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%/VirtSQLEDM6.png" style="wikiautogen"/>%BR%%BR% 16. In the <b>Choose your Database Objects</b> page select the <b>Tables</b> check box to select all tables in the NWIND 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%/VirtSQLEDM7.png" style="wikiautogen"/>%BR%%BR% 17. 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%/VirtSQLEDM8.png" style="wikiautogen"/>%BR%%BR% Creation for the Enity Data Model for the Microsoft SQL Server Northwind database is now complete.

sioc:id

e645b0b2d427f0125ca0c533d8bb378e

sioc:link

n4:VirtSQLEDM

sioc:has_container

n2:VOS

n5:has_services

n6:item

atom:title

VirtSQLEDM

atom:source

n2:VOS

atom:author

n13:this

atom:published

2017-06-13T05:40:09Z

atom:updated

2017-06-29T07:40:23Z

sioc:topic

n2:VOS