复合键实体框架 7"无法将属性添加到实体类型



我正在尝试创建一个enity,用于管理组织中具有角色的用户的成员资格。我想限制一个用户在一个组织中只能有一个成员资格。我通过创建一个复合密钥来实现这一点。然而,当我尝试创建初始迁移时,我遇到了错误:

InvalidOperationException:无法将属性"User"添加到实体类型"OrganizationLogin"中,因为实体类型"OrganizationLogin"上已存在同名的导航属性。

会员的实体

public class OrganizationLogin
{
    public int OrganizationLoginId { get; set; }
    public OrganizationRole Role { get; set; }
    public Organization Organization { get; set; }
    public OmegaUser User { get; set; } 
}

我尝试定义复合密钥的DBContext:

public class OmegaContext : IdentityDbContext<OmegaUser,OmegaRole,int>
{
    public DbSet<Log> Logs { get; set; }
    public DbSet<Organization> Organizations { get; set; }
    public DbSet<OrganizationLogin> OrganizationLogins { get; set; }
    public DbSet<OrganizationRole> OrganizationRoles { get; set; }
    public OmegaContext()
    {
    }
    protected override void OnModelCreating(ModelBuilder builder)
    {
        builder.Entity<OrganizationLogin>(orgLogin =>
        {
            orgLogin.HasAlternateKey(o => new {o.User, o.Organization});
        });
    }
}

如果我删除了OnModelCreating代码,迁移就会成功创建。

编辑:正如评论中所提到的,问题是我引用的是类,而不是具有实体

键的属性

根据要求,这里是我的解决方案:

public class OrganizationUnitMember
{
    public int OrganizationUnitMemberId { get; set; }
    public int UserId { get; set; }
    public int OrganizationUnitId { get; set; }
    [ForeignKey("UserId")]
    public virtual OmegaUser User { get; set; }
    [ForeignKey("OrganizationUnitId")]
    public virtual OrganizationUnit OrganizationUnit { get; set; }
    public int RoleId { get; set; }
    [ForeignKey("RoleId")]
    public virtual OrganizationRole Role { get; set; }
}

和DbContext:

protected override void OnModelCreating(ModelBuilder builder)
    {
        base.OnModelCreating(builder);
        builder.Entity<OrganizationUnit>(
            orgUnit =>
            {
                orgUnit.HasOne(ou => ou.Parent)
                    .WithMany(ou => ou.Children)
                    .OnDelete(DeleteBehavior.Restrict)
                    .HasForeignKey(ou => ou.ParentId);
            });
        builder.Entity<OrganizationUnitMember>(member =>
        {
            member.HasAlternateKey(m => new {m.OrganizationUnitId, m.UserId});
        });
    }

我必须添加引用实体的ID

最新更新