Entity Framework - Multiple navigation property

Question

I started working with Entity Framework and I have one BIG problem. I want a many-to-many relation between entities User and Role.

So I created 3 tables User, Role, UserRoles

Next I created 3 entities:

public class User
{
    public virtual int UserId { get; protected set; }
    public virtual string UserName { get; set; }
    public virtual string Password { get; set; }
    public virtual DateTime CreateDate { get; set; }
    public virtual ICollection<UserRole> Roles { get; set; }
    public virtual ICollection<UserRole> CreatedRoles { get; set; }
}

public class Role
{
    public virtual int RoleId { get; protected set; }
    public virtual string Name { get; set; }
}

public class UserRole
{
    public virtual int UserRoleId { get; protected set; }
    public virtual int UserId { get; set; }
    public virtual User User { get; set; }

    public virtual int RoleId { get; set; }
    public virtual Role Role { get; set; }
    public virtual DateTime CreateDate { get; set; }

    public virtual int CreateUserId { get; set; }
    public virtual User CreateUser { get; set; }
}

I want to separate mapped user from created user. And In this step Entity Framework start to throw a bugs.

Next I want navigate from User object to his mapped roles and to his created mappings.

Can I configure Entity Framework to do these things?

I think it is good relation in DB so I want create good Entities in .NET — Dawid Piekaruś
– Dawid Piekaruś, Commented Mar 5, 2016 at 16:07

Slava Utesinov · Accepted Answer · 2016-03-05 16:05:04Z

1

You should apply InverseProperty attribute:

public class User
{
    public virtual int UserId { get; protected set; }
    public virtual string UserName { get; set; }
    public virtual string Password { get; set; }
    public virtual DateTime CreateDate { get; set; }

    [InverseProperty("User")]
    public virtual ICollection<UserRole> Roles { get; set; }

    [InverseProperty("CreateUser")]
    public virtual ICollection<UserRole> CreatedRoles { get; set; }
}

answered Mar 5, 2016 at 16:05

Slava Utesinov

13.5k2 gold badges21 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework - Multiple navigation property

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related