Procedure
-
In the Data Model Entities
panel, right-click the element you want to set as a foreign key and select
Set the Foreign Key from the contextual
menu.
In this example, right-click the Director attribute from the Movie entity.
The Set the Foreign Key dialog
box pops up.
Note that a Foreign Key must always be a string.
-
Click the [...] button to open
the Select Xpath dialog box.
-
Browse to the Director attribute
Id and then click Add in the bottom of the dialog box.
The Xpath to the foreign key is displayed in the Set the Foreign Key dialog box.
-
Click OK to finish setting the
foreign key.
The foreign key is set to Director/Id under the Annotations node of the Director attribute in the Movie entity.
-
Follow the same steps to set the Movie attribute in the Customer entity as a foreign key which points to the Movie entity.
Results
In the Movie data model, the foreign
keys are added to link entities in the data model. You can also click the Design tab to view the relationships
between entities in a data model in a graphical designer.
For more information, see Browsing the
graphical view of a data model.