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

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

Namespace Prefixes

PrefixIRI
dctermshttp://purl.org/dc/terms/
n14http://vos.openlinksw.com:80/wiki/main/VOS/VirtIngresAssociations/
atomhttp://atomowl.org/ontologies/atomrdf#
foafhttp://xmlns.com/foaf/0.1/
n8http://vos.openlinksw.com/dataspace/services/wiki/
oplhttp://www.openlinksw.com/schema/attribution#
n2http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/
dchttp://purl.org/dc/elements/1.1/
n15http://vos.openlinksw.com/dataspace/dav#
rdfshttp://www.w3.org/2000/01/rdf-schema#
n9http://rdfs.org/sioc/services#
n10http://vos.openlinksw.com/dataspace/person/dav#
siocthttp://rdfs.org/sioc/types#
n16http://vos.openlinksw.com/dataspace/owiki/wiki/
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n18http://vos.openlinksw.com/dataspace/owiki#
n20http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtIngresAssociations/
n12http://vos.openlinksw.com/wiki/main/VOS/VirtIngresAssociations/
xsdhhttp://www.w3.org/2001/XMLSchema#
n13http://vos.openlinksw.com/dataspace/person/owiki#
siochttp://rdfs.org/sioc/ns#

Statements

Subject Item
n10:this
foaf:made
n2:VirtIngresAssociations
Subject Item
n15:this
sioc:creator_of
n2:VirtIngresAssociations
Subject Item
n8:item
n9:services_of
n2:VirtIngresAssociations
Subject Item
n18:this
sioc:creator_of
n2:VirtIngresAssociations
Subject Item
n16:VOS
sioc:container_of
n2:VirtIngresAssociations
atom:entry
n2:VirtIngresAssociations
atom:contains
n2:VirtIngresAssociations
Subject Item
n2:VirtIngresAssociations
rdf:type
sioct:Comment atom:Entry
dcterms:created
2017-06-13T05:38:23.260002
dcterms:modified
2017-06-29T07:37:51.802579
rdfs:label
VirtIngresAssociations
foaf:maker
n10:this n13:this
dc:title
VirtIngresAssociations
opl:isDescribedUsing
n20:sioc.rdf
sioc:has_creator
n18:this n15:this
sioc:attachment
n12:VirtIngresAssc02.png n12:VirtIngresAssc03.png n12:._.DS_Store n12:VirtIngresAssc01.png n12:.DS_Store n14:.DS_Store n14:._.DS_Store n12:VirtIngresAssc14.png n12:VirtIngresAssc12.png n12:VirtIngresAssc13.png n12:VirtIngresAssc10.png n12:VirtIngresAssc11.png n12:VirtIngresAssc08.png n12:VirtIngresAssc09.png n12:VirtIngresAssc06.png n12:VirtIngresAssc07.png n14:._.DS_Store.1SleHt n12:VirtIngresAssc04.png n12:VirtIngresAssc05.png
sioc:content
%VOSWARNING% %META:TOPICPARENT{name="VirtIngresEntityFrameworkUsage"}% ---+++Manually creating EDM Associations (FKs) for the Ingres Tutorial database The following steps will detail what is required to manually create *Associations* in your Entity Data Model. Before commencing the process, you will need to determine where these associations exist and their multiplicity (e.g., one-to-one, one-to-many, etc.). <i><b>NOTE:</b> These steps will need to be repeated for each association.</i> 1 The first Association I will deal with is the relationship between <b><code><nowiki>cust_orders</nowiki></code></b> and <b><code><nowiki>cust_info</nowiki></code></b>, identified by the presence of the Scalar Property <b><code><nowiki>cust_no</nowiki></code></b> in both entities. This is a one-to-one relationship, as an entry in a customer order may only be associated with one customer's information. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc02.png" style="wikiautogen"/>%BR%%BR% 1 To add the Association, right-click on the <b><code>Customer</code></b> entity. Then, click *Add* -> *Association*. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc03.png" style="wikiautogen"/>%BR%%BR% 1 You will now see the *Add Association* dialog. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc04.png" style="wikiautogen"/>%BR%%BR% 1 Hit *OK*. The diagram will be refreshed to include the newly created association.%BR%%BR% 1 You now need to edit the mappings associated with the newly created association, so right-click the association on the diagram and select *Table Mapping* to display the *Mapping Details* pane. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc05.png" style="wikiautogen"/>%BR%%BR% 1 Click the line that reads <b>&lt;Add a Table or View&gt;</b> to reveal a drop down list of all entities. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc06.png" style="wikiautogen"/>%BR%%BR% 1 Here you need to select the entity on the right/far side of the association (the entity where the foreign key exists). In this example, it is the <b><code><nowiki>cust_orders</nowiki></code></b> entity. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc07.png" style="wikiautogen"/>%BR%%BR% 1 The *Mapping Details* pane now refreshes to display both ends of the association. You will now be required to provide relevant target store data types in the *Column* column for the key fields, as depicted here. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc08.png" style="wikiautogen"/>%BR%%BR% 1 Once the mapping is complete, you can build the project using *Build* -> *Build Solution*. <i><b>NOTE:</b> It is worthwhile to (re)build as each association is made, since the error messages can be a little confusing.</i> %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc09.png" style="wikiautogen"/>%BR%%BR% 1 This should result in the following error, which is included here, since I (the author) found it misleading. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc10.png" style="wikiautogen"/>%BR%%BR% This error indicates that there are two sources &mdash; in this case, the <b><code><nowiki>cust_orders</nowiki></code></b> entity's Scalar Property <b><code><nowiki>cust_no</nowiki></code></b> and the Navigation Property <b><code><nowiki>cust_info</nowiki></code></b> in &mdash; which are being mapped to the same target column &mdash; the Ingres column <b><code><nowiki>cust_orders.cust_no</nowiki></code></b> &mdash; which is not supported. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc11.png" style="wikiautogen"/>%BR%%BR% 1 The solution is simple! Delete the mapping for Scalar Property <b><code><nowiki>cust_orders.cust_no</nowiki></code></b>. Its only purpose is to hold data representing a relationship/association (it is a Foreign Key), which has already been represented by the newly-created association and resulting Navigation Property <b><code><nowiki>cust_no</nowiki></code></b>.%BR%%BR% Right-click on <b><code><nowiki>cust_orders.cust_no</nowiki></code></b>. Then, click *Delete*. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc12.png" style="wikiautogen"/>%BR%%BR% 1 The model diagram will refresh to reflect this change. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc14.png" style="wikiautogen"/>%BR%%BR% 1 Build the project, again, using *Build* -> *Build Solution*. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc09.png" style="wikiautogen"/>%BR%%BR% 1 The project should now build fine. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc13.png" style="wikiautogen"/>%BR%%BR% You will need to repeat these steps for each association until you have a completed Entity Data Model. %BR%%BR%<img src="%ATTACHURLPATH%/VirtIngresAssc01.png" style="wikiautogen"/>%BR%%BR%
sioc:id
b7b219399a772c49f705a1783182e966
sioc:link
n2:VirtIngresAssociations
sioc:has_container
n16:VOS
n9:has_services
n8:item
atom:title
VirtIngresAssociations
atom:source
n16:VOS
atom:author
n10:this
atom:published
2017-06-13T05:38:23Z
atom:updated
2017-06-29T07:37:51Z
sioc:topic
n16:VOS
Subject Item
n2:VirtIngresEntityFrameworkUsage
sioc:links_to
n2:VirtIngresAssociations