EF报错：未指定属性映射，关联表插入失败求助

我有MeetingPollingQuestion和MeetingPollingParts两张表，MeetingPollingQuestion的主键MeetingPollingQuestionId是MeetingPollingParts的外键。我想先插入MeetingPollingQuestion，再用它的主键插入MeetingPollingParts数据，但遇到了「未指定属性映射」的错误，同时后续用Include查询时也报错。

插入代码 #

mf.MeetingPollingId = mpq.MeetingPollingId;
mf.MeetingPollingQuestionType = mpq.MeetingPollingQuestionType;
mf.SequenceOrder = mpq.SequenceOrder;

db.MeetingPollingQuestions.Add(mf);

var MeetingPollingPartList = new List<EFModel.MeetingPollingPart>();

foreach (var p in mpq.MeetingPollingParts)
{
    var mfParts = new EFModel.MeetingPollingPart();
    mfParts.MeetingPollingQuestionId = mf.MeetingPollingQuestionId;
    mfParts.Type = p.Type;
    MeetingPollingPartList.Add(mfParts);
}

db.MeetingPollingParts.AddRange(MeetingPollingPartList);

db.SaveChanges();
dbTran.Commit();

报错信息 #

映射片段从第4481行开始出现问题：未为MeetingPollingParts集合中的属性MeetingPollingPart.MeetingPollingQuestionMeetingPollingQuestionId、MeetingPollingPart.MeetingPollingQuestionMeetingPollingQuestionId1指定映射。
带有主键(PK)的实体无法往返

查询代码及报错 #

尝试用Include关联查询时，出现「MeetingPollings未包含MeetingPollingParts」错误：

var meetingPolling = db.MeetingPollings
                     .Include(x => x.MeetingPollingQuestions)
                     .Include(x => x.MeetingPollingParts)
                     .Single(x => x.MeetingPollingId == mpq.MeetingPollingId);

EF实体模型代码 #

MeetingPolling #

namespace Repository.EFModel
{
    using System;
    using System.Collections.Generic;
    
    public partial class MeetingPolling
    {
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
        public MeetingPolling()
        {
            this.MeetingPollingQuestions = new HashSet<MeetingPollingQuestion>();
        }
    
        public int MeetingPollingId { get; set; }
        public Nullable<int> MeetingId { get; set; }
        public Nullable<System.DateTime> StartDate { get; set; }
        public Nullable<System.DateTime> EndDate { get; set; }
    
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<MeetingPollingQuestion> MeetingPollingQuestions { get; set; }
    }
}

MeetingPollingQuestion #

namespace Repository.EFModel
{
    using System;
    using System.Collections.Generic;
    
    public partial class MeetingPollingQuestion
    {
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
        public MeetingPollingQuestion()
        {
            this.MeetingPollingParts = new HashSet<MeetingPollingPart>();
        }
    
        public int MeetingPollingQuestionId { get; set; }
        public string MeetingPollingQuestionType { get; set; }
        public Nullable<int> MeetingPollingId { get; set; }
        public Nullable<int> SequenceOrder { get; set; }
        public int MeetingPollingMeetingPollingId { get; set; }
    
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<MeetingPollingPart> MeetingPollingParts { get; set; }
        public virtual MeetingPolling MeetingPolling { get; set; }
    }
}

MeetingPollingPart #

namespace Repository.EFModel
{
    using System;
    using System.Collections.Generic;
    
    public partial class MeetingPollingPart
    {
        public int MeetingPollingParts { get; set; }
        public string Type { get; set; }
        public Nullable<int> MeetingPollingQuestionId { get; set; }
        public int MeetingPollingQuestionMeetingPollingQuestionId { get; set; }
    
        public virtual MeetingPollingQuestion MeetingPollingQuestion { get; set; }
    }
}

单元测试代码 #

MeetingPollingQuestion mpq = new MeetingPollingQuestion();
mpq.MeetingPollingId = 22;
mpq.MeetingPollingQuestionType = "MultipleChoice";
mpq.SequenceOrder = 1;
mpq.MeetingPollingParts = new List<MeetingPollingParts>();

MeetingPollingParts mpp1 = new MeetingPollingParts();
mpp1.Type = "Image";
mpp1.MeetingPollingPartsValues = new List<MeetingPollingPartsValues>();

MeetingPollingPartsValues mppv1 = new MeetingPollingPartsValues();
mppv1.FileManagerId = 500;
mpp1.MeetingPollingPartsValues.Add(mppv1);

mpq.MeetingPollingParts.Add(mpp1);

MeetingService ms = new MeetingService();
var r = ms.SaveMeetingPollingQuestion(mpq);

1. 映射错误根源：实体模型冗余外键属性 #

从报错信息和实体模型来看，核心问题是EF自动生成了冗余的外键属性，导致映射冲突：

• MeetingPollingQuestion中存在MeetingPollingId（手动定义）和MeetingPollingMeetingPollingId（EF自动生成），两者都是指向MeetingPolling的外键，属于重复定义。
• MeetingPollingPart中存在MeetingPollingQuestionId（手动定义）和MeetingPollingQuestionMeetingPollingQuestionId（EF自动生成），同样重复。

EF在检测到导航属性时，如果没有明确配置外键，会自动生成格式为[导航属性名][主键名]的外键属性，手动定义同名逻辑的外键会触发重复映射问题。

2. 修复步骤 #

步骤1：清理实体模型中的冗余外键 #

• 删除MeetingPollingQuestion中的MeetingPollingMeetingPollingId属性
• 删除MeetingPollingPart中的MeetingPollingQuestionMeetingPollingQuestionId属性
• 修正MeetingPollingPart的主键命名：当前MeetingPollingParts与实体名混淆，改为MeetingPollingPartId符合命名规范

修改后的MeetingPollingQuestion：

public partial class MeetingPollingQuestion
{
    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
    public MeetingPollingQuestion()
    {
        this.MeetingPollingParts = new HashSet<MeetingPollingPart>();
    }

    public int MeetingPollingQuestionId { get; set; }
    public string MeetingPollingQuestionType { get; set; }
    public Nullable<int> MeetingPollingId { get; set; }
    public Nullable<int> SequenceOrder { get; set; }

    [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
    public virtual ICollection<MeetingPollingPart> MeetingPollingParts { get; set; }
    public virtual MeetingPolling MeetingPolling { get; set; }
}

修改后的MeetingPollingPart：

public partial class MeetingPollingPart
{
    public int MeetingPollingPartId { get; set; } // 修正主键名
    public string Type { get; set; }
    public Nullable<int> MeetingPollingQuestionId { get; set; }

    public virtual MeetingPollingQuestion MeetingPollingQuestion { get; set; }
}

步骤2：明确配置EF外键映射（推荐） #

为避免EF自动生成冗余属性，可通过数据注解或Fluent API明确配置外键：

数据注解方式

在MeetingPollingQuestion的导航属性上添加[ForeignKey]：

[ForeignKey("MeetingPollingId")]
public virtual MeetingPolling MeetingPolling { get; set; }

在MeetingPollingPart的导航属性上添加：

[ForeignKey("MeetingPollingQuestionId")]
public virtual MeetingPollingQuestion MeetingPollingQuestion { get; set; }

Fluent API方式（在DbContext的OnModelCreating中配置）

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    // 配置MeetingPolling与MeetingPollingQuestion的关系
    modelBuilder.Entity<MeetingPolling>()
        .HasMany(m => m.MeetingPollingQuestions)
        .WithRequired(q => q.MeetingPolling)
        .HasForeignKey(q => q.MeetingPollingId);

    // 配置MeetingPollingQuestion与MeetingPollingPart的关系
    modelBuilder.Entity<MeetingPollingQuestion>()
        .HasMany(q => q.MeetingPollingParts)
        .WithOptional(p => p.MeetingPollingQuestion)
        .HasForeignKey(p => p.MeetingPollingQuestionId);
}

步骤3：优化插入代码，利用EF导航属性自动关联 #

无需手动设置外键，直接将MeetingPollingPart添加到MeetingPollingQuestion的MeetingPollingParts集合中，EF会自动处理外键赋值：

mf.MeetingPollingId = mpq.MeetingPollingId;
mf.MeetingPollingQuestionType = mpq.MeetingPollingQuestionType;
mf.SequenceOrder = mpq.SequenceOrder;

// 直接将子实体添加到导航属性集合
foreach (var p in mpq.MeetingPollingParts)
{
    var mfParts = new EFModel.MeetingPollingPart();
    mfParts.Type = p.Type;
    mf.MeetingPollingParts.Add(mfParts);
}

db.MeetingPollingQuestions.Add(mf);
db.SaveChanges();
dbTran.Commit();

步骤4：修复查询报错 #

MeetingPolling实体中不存在MeetingPollingParts集合，因为MeetingPollingParts是MeetingPollingQuestion的子实体，正确的查询应通过MeetingPollingQuestions导航到MeetingPollingParts：

var meetingPolling = db.MeetingPollings
                     .Include(x => x.MeetingPollingQuestions.Select(q => q.MeetingPollingParts))
                     .Single(x => x.MeetingPollingId == mpq.MeetingPollingId);

内容的提问来源于stack exchange，提问作者Jefferson