| Attributes | Values |
|---|
| type
| |
| Date Created
| |
| Date Modified
| |
| label
| |
| maker
| |
| Title
| |
| isDescribedUsing
| |
| has creator
| |
| attachment
| |
| content
| - %VOSWARNING%
%META:TOPICPARENT{name="VirtPostgresEntityFrameworkUsage"}%
---+++Creating an Entity Data Model (EDM) for the <nop>PostgreSQL Northwind database
The following steps can be used to create an Entity Data Model (EDM) for the Northwind database imported into <nop>PostgreSQL:
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 your 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 in 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%/VirtPGREDM1.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 and click <b>Continue</b>.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtPGREDM2.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%/VirtPGREDM3.png" style="wikiautogen"/>%BR%%BR%
13. Use the Select Database From List dialog to select the PGR catalog.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtPGREDM4.png" style="wikiautogen"/>%BR%%BR%
14. Press the <b>Test Connection</b> dialog to verify that the database is accessible.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtPGREDM5.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 an ADO.Net Data Service) and click <b>Next</b>.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtPGREDM6.png" style="wikiautogen"/>%BR%%BR%
16. In the <b>Choose your Database Objects</b> page, tick the <b>Tables</b> check box to select all tables in the Northwind 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%/VirtPGREDM7.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%/VirtPGREDM8.png" style="wikiautogen"/>%BR%%BR%
Creation for the Entity Data Model for the <nop>PostgreSQL Northwind database is now complete.
|
| id
| - 6cc7b05f270459d3467eb43b745f8614
|
| link
| |
| has container
| |
| http://rdfs.org/si...ices#has_services
| |
| atom:title
| |
| atom:source
| |
| atom:author
| |
| atom:published
| |
| atom:updated
| |
| topic
| |
| is made
of | |
| is container of
of | |
| is link
of | |
| is http://rdfs.org/si...vices#services_of
of | |
| is links to
of | |
| is creator of
of | |
| is atom:entry
of | |
| is atom:contains
of | |
![[RDF Data]](/fct/images/sw-rdf-blue.png)
![[cxml]](/fct/images/cxml_doc.png)
![[csv]](/fct/images/csv_doc.png)
![[text]](/fct/images/ntriples_doc.png)
![[turtle]](/fct/images/n3turtle_doc.png)
![[ld+json]](/fct/images/jsonld_doc.png)
![[rdf+json]](/fct/images/json_doc.png)
![[rdf+xml]](/fct/images/xml_doc.png)
![[atom+xml]](/fct/images/atom_doc.png)
![[html]](/fct/images/html_doc.png)