Multiple foreign keys to many tables

Question

I have the following classes:

public class Project
{
    public int ID { get; set; }
    public string Name { get; set; }
    ...
    // Navigation
    public virtual IEnumerable<Task> Tasks { get; set; }
    //public virtual IEnumerable<Message> Messages { get; set; } // ???
}

public class Task
{
    public int ID { get; set; }
    public int ProjectID { get; set; }
    public string Name { get; set; }
    ...
    // Navigation
    //public virtual IEnumerable<Message> Messages { get; set; } // ???
}

public class Message
{
    public int ID { get; set; }
    public string Comment { get; set; }
    ...
    // Foreign Keys ??
}

Basically:

Project will have many Task
Project will have many Message
Task will have many Message
Each Message will belong to either a Project or Task

How will I write the database, as well as write the EF code to achieve this? I want to be able to use Linq syntax for eg. List<Message> messages = project.Messages.ToList();

I have found this alternative design but not sure how the navigation properties will look.

You're using code-first design, right? Do you need to manually add the SQL tables and keys for this? — Codeman, Jan 16 '13 at 00:37
Sorry - Yes, it's code-first. I will take care of the sql tables (prefer to), but need to work this out first. — praveensewak, Jan 16 '13 at 01:58

score 0 · Answer 1 · answered Jan 16 '13 at 02:59

I think you are pretty much there. Could you try this?

public class Project
{
    public int ID { get; set; }
    public string Name { get; set; }
    ...
    // Navigation
    public virtual IEnumerable<Task> Tasks { get; set; }
    public virtual IEnumerable<Message> Messages { get; set; }
}

public class Task
{
    public int ID { get; set; }
    public int ProjectID { get; set; }
    public string Name { get; set; }
    ...
    // Navigation
    public virtual IEnumerable<Message> Messages { get; set; }
}

public class Message
{
    public int ID { get; set; }
    public string Comment { get; set; }
    ...
    public int? ProjectId {get;set;}
    public int? TaskId {get;set;}

    public virtual Project {get;set;}
    public virtual Task {get;set;}
}

Multiple foreign keys to many tables

1 Answers1