%VOSWARNING%


%META:TOPICPARENT{name="VirtOJDBCEntityFrameworkUsage"}%

---+++Creating an Entity Data Model (EDM) for the ODBC to JDBC Bridge Northwind database

The following steps can be used to create an Entity Data Model (EDM) for the ODBC to JDBC Bridge 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 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%/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>jdbc</b> database from the drop down list.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtOJDBCEDM4.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%/VirtOJDBCEDM5_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%/VirtOJDBCEDM6.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 JDBC 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%/VirtOJDBCEDM7.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%/VirtOJDBCEDM8.png" style="wikiautogen"/>%BR%%BR%

Creation for the Entity Data Model for the ODBC to JDBC Bridge Northwind database is now complete.