This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product. Otherwise - post away!
I have two entities "User" and "Task".
Now I like to describe the following dependencies:
This works fine, I have a List of Tasks in my User class and a User in my Task class with a "userId" field in my Task table.
What I need is a class "Task" with 2 properties of type "User", e.g. "CreatedByUser" and "AssignedToUser". But how do I model this within the designer?
How do I realize this with the Designer?
Drag two arrows from User to Task, and give them appropriate names. See attached image.
Don't forget you'll also need two foreign key fields, e.g. AssignedToUserId and CreatedByUserId, and to set the Key Column Name on the arrows appropriately.