This HTML5 document contains 79 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

n2:VirtIngresEDM

Subject Item

n27:this

sioc:creator_of

n2:VirtIngresEDM

Subject Item

n22:item

n21:services_of

n2:VirtIngresEDM

Subject Item

n29:this

sioc:creator_of

n2:VirtIngresEDM

Subject Item

n17:VOS

sioc:container_of

n2:VirtIngresEDM

atom:entry

n2:VirtIngresEDM

atom:contains

n2:VirtIngresEDM

Subject Item

n2:VirtIngresEntityFrameworkUsage

sioc:links_to

n2:VirtIngresEDM

Subject Item

n2:VirtIngresEDM

rdf:type

atom:Entry sioct:Comment

dcterms:created

2017-06-13T05:44:00.280083

dcterms:modified

2017-06-29T07:37:53.350098

rdfs:label

VirtIngresEDM

foaf:maker

n13:this n25:this

dc:title

VirtIngresEDM

opl:isDescribedUsing

n67:rdf

sioc:has_creator

n29:this n27:this

sioc:attachment

n4:png n5:png n6:png n8:FErFYU n10:png n11:png n14:png n15:png n16:png n18:png n19:png n20:png n23:DS_Store n24:DS_Store n28:png n30:png n31:png n32:png n33:NYZnr2 n35:Q6ViQh n37:oG9H2R n38:p8miVT n39:DS_Store n40:png n41:kEnFkJ n42:png n43:png n44:9d07TD n45:TOMae3 n46:png n47:pIAT77 n48:png n49:png n50:png n51:png n52:png n53:png n54:png n55:png n56:png n57:png n58:png n59:png n60:png n61:png n62:png n63:png n64:DS_Store n65:png

sioc:content

%VOSWARNING% %META:TOPICPARENT{name="VirtIngresEntityFrameworkUsage"}% ---+++Creating an Entity Data Model (EDM) for the Ingres Tutorial database The following steps can be used to create an Entity Data Model (EDM) for the Ingres Tutorial 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 the 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 of the <b>Solution Explorer</b> pane. Then, select the <b>Add</b> -> <b>New Item</b> menu option. %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>TUT</b> database from the drop down list. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresEDM4.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%/VirtIngresEDM5_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%/VirtIngresEDM2.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 TUT catalog for addition to the Entity Data Model. Set the <b>Model Namespace</b> to <b><nop>VirtuosoModel</b> and click <b>Finish</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresEDM3.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%/VirtIngresEDM6.png" style="wikiautogen"/>%BR%%BR% Creation of the Entity Data Model for the Ingres Tutorial database is now complete.

sioc:id

4cc07fa7dd668ddae44c298c3545e543

sioc:link

n2:VirtIngresEDM

sioc:has_container

n17:VOS

n21:has_services

n22:item

atom:title

VirtIngresEDM

atom:source

n17:VOS

atom:author

n13:this

atom:published

2017-06-13T05:44:00Z

atom:updated

2017-06-29T07:37:53Z

sioc:topic

n17:VOS