Many-to-many relationship between entities of same type in MVC3

I have an ASP.NET MVC3 application, where I use Entity Framework 4.3 Code-First and Migrations.

I've been trying to create a many-to-many relationship between entities of the same type, but when I scaffold the migration with Migrations, it generates a one-to-one relationship.

The idea is that one user should be able to follow multiple other users (think Twitter).

My User model look something like this:

public class User
{
    public int UserId { get; set; }
    public string Name { get; set; }
    public DateTime Registered { get; set; }
    ...
    public virtual ICollection<User> Follows { get; set; }
}

When I scaffold the the added Follows-property, I get a migration like this:

public partial class FollowUser : DbMigration
{
    public override void Up()
    {
        AddColumn("User", "User_UserId", c => c.Int());
        AddForeignKey("User", "User_UserId", "User", "UserId");
        CreateIndex("User", "User_UserId");
    }

    ...
}

So Entity Framework interprets my model as a one-to-one relationship between two users.

How can I create a many-to-many relationship between entities of the same type?

Answers


Since It is a Many to Many Self Joined relationship, User entity should have a Followers and Following properties both of Type User. So Let us alter your class to include those

public class User
{
    public int ID { get; set; }
    public string Name { get; set; }       
    public virtual ICollection<User> Followers { get; set; }
    public virtual ICollection<User> Following { get; set; }
}

Now update the DbContext class to have a Property which returns the Users

 public DbSet<User> Users { set; get; }

We need to tell EntityFramework that we need to have a many to many relations ship between these two. So Let us do that with Fluent API by overriding OnModelCreating method

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Entity<User>().HasMany(m => m.Followers).WithMany(p => p.Following).Map(w => w.ToTable("User_Follow").MapLeftKey("UserId").MapRightKey("FollowerID"));
    base.OnModelCreating(modelBuilder);
}

Now Entity Framework will create the tables like this.

Note that we explicitly told Entity Framework to use UserId and FollowerId as the Forign Key column name. If we havent mentioned that, EF will use User_ID and User_ID1 as the column names.


Need Your Help

How can I keep a group of buttons centralized on the right side of the footer?

html css button footer

I've been trying to keep four buttons centralized on the right side of the footer, but it seems like the footer is set to percentage instead of pixels, I've tried to set it to percentage, but it ig...

How to read a specified xml node value using LINQ?

c# linq xml-parsing

I'd like to read the browser and language values from the attached xml file when I specify the VM name value. I've tried to run the below method a number of time but I keep getting errors. Can anyb...