The first Association I will deal with is the relationship between cust_orders and cust_info, identified by the presence of the Scalar Property cust_no in both entities. This is a one-to-one mpmprelationship, as an entry in a customer order may only be associated with one customer's information.

Figure 8.174. Association

To add the Association, right click on the Customer entity then Add -> Association.

Figure 8.175. add the Association

You will now see the Add Association dialog.

Figure 8.176. Add Association dialog

Once you then hit OK the diagram is refreshed to include the newly created association.

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.

Figure 8.177. Navigation Property name

Click that line reading <Add a Table or View> to reveal a drop down list of all entities.

Figure 8.178. Add a Table or View

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 cust_orders entity.

Figure 8.179. Entity

The Mapping Details pane now refreshes to display both ends of the association, requiring that you provide relevant target store data types in the Column column for the key fields, as depicted here.

Figure 8.180. Mapping Details

Once the mapping is complete, you can build the project using Build -> Build Solution. NOTE: It is worthwhile building as each association is made, since the error messages can be a little confusing.

Figure 8.181. Build the project

This should result in the following error:

Figure 8.182. Error

This error indicates that there are two sources - in this case, the cust_orders entity's Scalar Property cust_no and the Navigation Property cust_info in - which are being mapped to the same target column - the Ingres column cust_orders.cust_no - which is not supported.

Figure 8.183. Error

The solution is simple! Simply delete the mapping for Scalar Property cust_orders.cust_no since 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 cust_no.

Right-click on cust_orders.cust_no then Delete.

Figure 8.184. delete the mapping

The model diagram will refresh to reflect this change.

Figure 8.185. Model Diagram

Build the project, again, using Build -> Build Solution.

Figure 8.186. Build project

The project should now be fine.

Figure 8.187. Build Project