时间戳

首页 > 解决方案 > 实体框架中相同类型的多个外键

c# - 实体框架中相同类型的多个外键

问题描述

我的Issue实体有 2 个FK关于User实体的字段，如下所示。尽管我正确配置了属性以防止创建额外的Xxx_Id字段而不是PropertyNameId，但Xxx_Id除了字段之外，表中还创建了一个PropertyNameId字段。在此示例User_Id中，字段是在Issue表中创建的，此外AssigneeId还有ReporterId字段。这里有什么错误吗？是否HashSet在导致此额外字段的User实体中？User_Id

问题：

public class Issue : BaseEntity
{
    [Key]
    public int Id { get; set; }

    //Foreign key for Reporter (User entity)
    public short ReporterId { get; set; }

    //Foreign key for Assignee (User entity)
    public short AssigneeId { get; set; }

    [ForeignKey("ReporterId")]
    public virtual User Reporter { get; set; }

    [ForeignKey("AssigneeId")]
    public virtual User Assignee { get; set; }
}

用户：

public class User : BaseEntity 
{
    [Key]
    public short Id { get; set; }

    public string UserName { get; set; }

    public string Email { get; set; }

    //code omitted for brevity 

    public User()
    {
        Issues = new HashSet<Issue>();
        //code omitted for brevity 
    }        

    public virtual ICollection<Issue> Issues { get; set; }

    //code omitted for brevity 
}

以下是迁移文件中的相关行：

CreateTable(
            "Issue",
            c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ReporterId = c.Short(nullable: false),
                    AssigneeId = c.Short(nullable: false),
                    User_Id = c.Short() //???
                })
            .PrimaryKey(t => t.Id)
            .ForeignKey("com.User", t => t.User_Id)  //???
            .ForeignKey("com.User", t => t.AssigneeId)
            .ForeignKey("com.User", t => t.ReporterId)
            .Index(t => t.ReporterId)
            .Index(t => t.AssigneeId)
            .Index(t => t.User_Id);  //???

标签： c#sql-serverasp.net-mvcentity-frameworkef-code-first

解决方案

当您尝试创建多个ForeignKey相同类型时，您的模型类设置应如下所示：

public class User : BaseEntity
{
    public User()
    {
        ReporterIssues = new HashSet<Issue>();
        AssigneeIssues = new HashSet<Issue>();
    }

    [Key]
    public short Id { get; set; }
    public string UserName { get; set; }
    public string Email { get; set; }

    // Navigation properties
    public virtual ICollection<Issue> ReporterIssues { get; set; }
    public virtual ICollection<Issue> AssigneeIssues { get; set; }
}

public class Issue : BaseEntity
{
    [Key]
    public int Id { get; set; }
    public short ReporterId { get; set; }
    public short AssigneeId { get; set; }

    // Navigation properties
    public virtual User Reporter { get; set; }
    public virtual User Assignee { get; set; }
}

然后在OnModelCreating配置中如下：

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
        base.OnModelCreating(modelBuilder);

        modelBuilder.Entity<User>().HasMany(u => u.AssigneeIssues)
            .WithRequired(i => i.Assignee).HasForeignKey(a => a.AssigneeId)
            .WillCascadeOnDelete(false); // <-- cascade delete must be false

        modelBuilder.Entity<User>().HasMany(u => u.ReporterIssues)
            .WithRequired(i => i.Reporter).HasForeignKey(a => a.ReporterId)
            .WillCascadeOnDelete(false); // <-- cascade delete must be false
 }

推荐阅读