This HTML5 document contains 44 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:VirtFirebirdEDM

Subject Item

n28:this

sioc:creator_of

n2:VirtFirebirdEDM

Subject Item

n6:item

n7:services_of

n2:VirtFirebirdEDM

Subject Item

n10:this

sioc:creator_of

n2:VirtFirebirdEDM

Subject Item

n5:VOS

sioc:container_of

n2:VirtFirebirdEDM

atom:entry

n2:VirtFirebirdEDM

atom:contains

n2:VirtFirebirdEDM

Subject Item

n2:VirtFirebirdEDM

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T05:46:25.486390

dcterms:modified

2017-06-29T07:37:23.361573

rdfs:label

VirtFirebirdEDM

foaf:maker

n13:this n22:this

dc:title

VirtFirebirdEDM

opl:isDescribedUsing

n16:rdf

sioc:has_creator

n10:this n28:this

sioc:attachment

n14:png n17:png n18:png n19:png n20:png n21:png n23:png n24:png n25:png n26:png n27:png n29:png n30:png n31:png n32:png

sioc:content

%META:TOPICPARENT{name="VirtFirebirdEntityFrameworkUsage"}% ---+++Creating an Entity Data Model (EDM) for the Firebird employee database The following steps can be used to create an Entity Data Model (EDM) for the Firebird employee database: 1 Launch the Visual Studio 2008 SP1 IDE. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdEDM_01.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% <img src="%ATTACHURLPATH%/VirtFirebirdEDM_02.png" style="wikiautogen"/>%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>employee</b>, and click <b>OK</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdEDM_03.png" style="wikiautogen"/>%BR%%BR% 1 This will create a new project called <b><nop>employee</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdEDM_04.png" style="wikiautogen"/>%BR%%BR% 1 Select the <b>Project</b> -> <b>Add New Item</b> menu option. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdEDM_05.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>Model1.edmx</b> and click <b>Add</b> to start the creation of the ADO.Net Entity Data Model. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdEDM_06.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%/VirtFirebirdEDM_07.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%/VirtFirebirdEDM_08.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 displayed and click <b>Continue</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdEDM_09.png" style="wikiautogen"/>%BR%%BR% 1 In the <b>Connection Properties</b> dialog specify the <b>hostname</b>, <b>portno</b>, <b>username</b> and <b>password</b> for the target Virtuoso Server and check the <b>Save Password</b> check box. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdEDM_10.png" style="wikiautogen"/>%BR%%BR% 1 Select the <b>Select Database From List</b> radio button and choose <b>employee</b> from the drop down list %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdEDM_11.png" style="wikiautogen"/>%BR%%BR% 1 Press the <b>Test Connection</b> dialog to verify the database is accessible. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdEDM_12.png" style="wikiautogen"/>%BR%%BR% 1 Set the <b>entity connect string</b> name to <b>employeeEntities</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%/VirtFirebirdEDM_13.png" style="wikiautogen"/>%BR%%BR% 1 In the <b>Choose your Database Objects</b> page select the <b>Tables</b> check box to select all tables in the employee catalog for addition to the Enity Data Model, set the <b>Model Namespace</b> to <b>employeeModel</b> and click <b>Finish</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdEDM_14.png" style="wikiautogen"/>%BR%%BR% 1 The <b>Model1.edmx</b> EDM will be created with the tables and relationships displayed in the Visual Studio IDE %BR%%BR%<img src="%ATTACHURLPATH%/VirtFirebirdEDM_15.png" style="wikiautogen"/>%BR%%BR% Creation for the Enity Data Model for the Firebird employee database is now complete.

sioc:id

d0fd19644cabbb5fc2d1e95b442916fe

sioc:link

n2:VirtFirebirdEDM

sioc:has_container

n5:VOS

n7:has_services

n6:item

atom:title

VirtFirebirdEDM

atom:source

n5:VOS

atom:author

n13:this

atom:published

2017-06-13T05:46:25Z

atom:updated

2017-06-29T07:37:23Z

sioc:topic

n5:VOS