Question about a mapping

Hi,

I have two entities "User" and "Task".

Now I like to describe the following dependencies:

1. A "User" has one or more "Tasks" assigned, or in other words a "Task" needs to be assigned to a "User". I did this with a 1 to n association from "User" to "Task".

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.

1. Now, each "Task" should have the Information which "User" created the task too. So I need another User property in my Task class, which is different from the one from 1, because the user who created the task must not be to the one the task is assigned to.

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?

Thanks Kay

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.

Works perfect, thank you!