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

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

PrefixNamespace IRI
dctermshttp://purl.org/dc/terms/
atomhttp://atomowl.org/ontologies/atomrdf#
foafhttp://xmlns.com/foaf/0.1/
n28http://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/
n16http://vos.openlinksw.com/dataspace/dav#
rdfshttp://www.w3.org/2000/01/rdf-schema#
n29http://rdfs.org/sioc/services#
siocthttp://rdfs.org/sioc/types#
n4http://vos.openlinksw.com/dataspace/person/dav#
n9http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs09.
n25http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs03.
n26http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs04.
n27http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs01.
n30http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs02.
n32http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs07.
n33http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs08.
n34http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs05.
n35http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs06.
n7http://vos.openlinksw.com/dataspace/owiki/wiki/
rdfhttp://www.w3.org/1999/02/22-rdf-syntax-ns#
n36http://vos.openlinksw.com/dataspace/owiki#
n8http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs12.
n10http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs10.
n11http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs15.
n12http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs16.
n13http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs13.
n14http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs14.
n15http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs19.
n18http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs17.
n21http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs18.
n6http://vos.openlinksw.com/wiki/main/VOS/VirtOODBCAssociations/AccessEDMFKs11.
xsdhhttp://www.w3.org/2001/XMLSchema#
n23http://vos.openlinksw.com/dataspace/person/owiki#
siochttp://rdfs.org/sioc/ns#
n20http://vos.openlinksw.com/dataspace/owiki/wiki/VOS/VirtOODBCAssociations/sioc.
Subject Item
n4:this
foaf:made
n2:VirtOODBCAssociations
Subject Item
n16:this
sioc:creator_of
n2:VirtOODBCAssociations
Subject Item
n28:item
n29:services_of
n2:VirtOODBCAssociations
Subject Item
n36:this
sioc:creator_of
n2:VirtOODBCAssociations
Subject Item
n7:VOS
sioc:container_of
n2:VirtOODBCAssociations
atom:entry
n2:VirtOODBCAssociations
atom:contains
n2:VirtOODBCAssociations
Subject Item
n2:VirtOODBCAssociations
rdf:type
atom:Entry sioct:Comment
dcterms:created
2017-06-13T05:48:29.883594
dcterms:modified
2017-06-29T07:39:06.486781
rdfs:label
VirtOODBCAssociations
foaf:maker
n4:this n23:this
dc:title
VirtOODBCAssociations
opl:isDescribedUsing
n20:rdf
sioc:has_creator
n16:this n36:this
sioc:attachment
n6:png n8:png n9:png n10:png n11:png n12:png n13:png n14:png n15:png n18:png n21:png n25:png n26:png n27:png n30:png n32:png n33:png n34:png n35:png
sioc:content
--+++Manually creating EDM Associations (FKs) for the Microsoft Access Northwind database The following steps will detail what is required to manually create *Associations* in your Entity Data Model. You will need to determine where these associations exist and their multiplicity (one-to-one, one-to-many, etc.) before commencing with the following steps. <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>Customer</code></b> and <b><code>Invoice</code></b>, identified by the presence of the scalar property <b><code>Cust_Num</code></b> in both entities. This is a one-to-many relationship, as a Customer may have any number of Invoices. %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs01.png" style="wikiautogen"/>%BR%%BR% 1 To add the Association, right click on the <b><code>Customer</code></b> entity, then *Add* -> *Association*. %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs02.png" style="wikiautogen"/>%BR%%BR% 1 You will now see the *Add Association* dialog. %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs04.png" style="wikiautogen"/>%BR%%BR% 1 For this association, the only thing that needs changing is the default name assigned to the *Navigation Property*. Change the default from <b><code>Invoice</code></b> to <b><code>invoices</code></b> on the <b><code>Customer</code></b> end of the association.%BR%%BR%This better reflects the multiplicity of the association such that a Customer is associated with zero or many Invoices (plural). %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs05.png" style="wikiautogen"/>%BR%%BR%Typically, here is where you will - 1) Select the entity at each end of the association, 2) Select the multiplicity of each end of the association, and 3) Provide suitable names for the association and its navigation properties. %BR%%BR% 1 Hit *OK*. The diagram will be refreshed to include the newly created association. %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs06.png" style="wikiautogen"/>%BR%%BR% 1 You now need to edit the mappings associated with the newly created association, so right-click the association on the diagram. Then, select *Table Mapping* to display the *Mapping Details* pane. %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs07.png" style="wikiautogen"/>%BR%%BR% 1 Click the line which reads <b>&lt;Add a Table or View&gt;</b> to reveal a drop down list of all entities. %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs08.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).%BR%%BR%In this example, it is the <b><code>Invoice</code></b> entity. %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs09.png" style="wikiautogen"/>%BR%%BR% 1 The *Mapping Details* pane now refreshes to display both ends of the association. Now, you must provide relevant target store data types in the *Column* column for the key fields, as depicted here. %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs10.png" style="wikiautogen"/> %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs11.png" style="wikiautogen"/> %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs12.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 building as each association is made, since the error messages can be a little confusing.</i> %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs13.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%/AccessEDMFKs14.png" style="wikiautogen"/>%BR%%BR% This error indicates that there are two source columns &mdash; in this case, the Invoice entity's Scalar Property <b><code>Cust_Num</code></b> and Navigation Property <b><code>Customer</code></b> &mdash; which are both mapped to the same target column &mdash; the Progress column <b><code>Invoice.Cust_Num</code></b> &mdash; and this is not supported. %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs15.png" style="wikiautogen"/>%BR%%BR% 1 The solution is simple! Simply delete the mapping of the Scalar Property <b><code>Invoice.Cust_Num</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>Customer</code></b>.%BR%%BR% Right click on <b><code>Invoice.Cust_Num</code></b> then *Delete*. %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs16.png" style="wikiautogen"/>%BR%%BR% 1 The model diagram will refresh to reflect this change. %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs17.png" style="wikiautogen"/>%BR%%BR% 1 Build the project, again, using *Build* -> *Build Solution*. %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs13.png" style="wikiautogen"/>%BR%%BR% 1 The project should now build fine. %BR%%BR%<img src="%ATTACHURLPATH%/AccessEDMFKs18.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%/AccessEDMFKs19.png" style="wikiautogen"/>%BR%%BR%
sioc:id
b0fcd8b34db4c5b4e0e47a7b85b3ff20
sioc:link
n2:VirtOODBCAssociations
sioc:has_container
n7:VOS
n29:has_services
n28:item
atom:title
VirtOODBCAssociations
atom:source
n7:VOS
atom:author
n4:this
atom:published
2017-06-13T05:48:29Z
atom:updated
2017-06-29T07:39:06Z
sioc:topic
n7:VOS