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

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

Subject Item

n8:this

foaf:made

n4:VirtOracleEDM

Subject Item

n11:this

sioc:creator_of

n4:VirtOracleEDM

Subject Item

n36:item

n37:services_of

n4:VirtOracleEDM

Subject Item

n2:this

sioc:creator_of

n4:VirtOracleEDM

Subject Item

n6:VOS

sioc:container_of

n4:VirtOracleEDM

atom:entry

n4:VirtOracleEDM

atom:contains

n4:VirtOracleEDM

Subject Item

n4:VirtOracleEDM

rdf:type

atom:Entry sioct:Comment

dcterms:created

2017-06-13T05:49:55.503438

dcterms:modified

2017-06-29T07:39:15.177362

rdfs:label

VirtOracleEDM

foaf:maker

n16:this n8:this

dc:title

VirtOracleEDM

opl:isDescribedUsing

n10:rdf

sioc:has_creator

n2:this n11:this

sioc:attachment

n7:p9dDo7 n13:png n14:png n17:png n18:wmn77b n19:DS_Store n20:png n21:png n22:png n23:png n24:png n25:DS_Store n26:png n27:png n28:png n29:png n30:png n32:png n33:png n34:DS_Store n35:png n38:DS_Store

sioc:content

%VOSWARNING% %META:TOPICPARENT{name="VirtOracleEntityFrameworkUsage"}% ---+++Creating an Entity Data Model (EDM) for the Oracle Human Resources database The following steps can be used to create an Entity Data Model (EDM) for the Oracle Human Resources 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 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%/VirtOracleEDM1.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%/VirtOracleEDM2.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>HR</b> database from the drop down list. %BR%%BR%<img src="%ATTACHURLPATH%/VirtOracleEDM4.png" style="wikiautogen"/>%BR%%BR% 1 Press the <b>Test Connection</b> dialog to verify the database is accessible. %BR%%BR%<img src="%ATTACHURLPATH%/VirtOracleEDM5.png" style="wikiautogen"/>%BR%%BR% 1 Click <b>OK</b> to add the connection.%BR% %BR%%BR%<img src="%ATTACHURLPATH%/VirtOracleEDM5_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 an ADO.Net Data Service) and click <b>Next</b>. %BR%%BR%<img src="%ATTACHURLPATH%/VirtOracleEDM6.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 HR 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%/VirtOracleEDM7.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%/VirtOracleEDM8.png" style="wikiautogen"/>%BR%%BR% Creation for the Entity Data Model for the Oracle Human Resources database is now complete.

sioc:id

ade190abc86caa135f1603679f812afa

sioc:link

n4:VirtOracleEDM

sioc:has_container

n6:VOS

n37:has_services

n36:item

atom:title

VirtOracleEDM

atom:source

n6:VOS

atom:author

n8:this

atom:published

2017-06-13T05:49:55Z

atom:updated

2017-06-29T07:39:15Z

sioc:topic

n6:VOS