如何用LINQ将List<Qeustions>映射为EF实体集合？解决CS1503错误

原代码核心问题 #

1. 重复添加同一实体实例：你在循环外只创建了一个Qeustions对象，循环中反复修改该对象的属性并添加到EF上下文，最终数据库只会插入最后一次赋值的单条数据，且上下文会出现实体跟踪冲突。
2. CS1503错误原因：大概率是代码某处误将List<Qeustions>类型的questions当作单个Qeustions实例传入（比如变量名拼写错误、调用Add时传了集合而非单个实体）。

方案1：LINQ+手动映射（推荐） #

利用LINQ的Select生成新的EF实体集合，批量添加到上下文：

// 通过LINQ创建新的Qeustions实体集合
var questionEntities = questions.Select(item => new Qeustions
{
    Respondent = item.Respondent,
    InternalMeetings = item.InternalMeetings,
    ClientMeetings = item.ClientMeetings,
    EmailsPhoneSkypeCalls = item.EmailsPhoneSkypeCalls,
    Research = item.Research,
    DbDesign = item.DbDesign,
    ArchitectureDesignAndPlanning = item.ArchitectureDesignAndPlanning,
    BackEndDevelopment = item.BackEndDevelopment,
    FrontEndDevelopment = item.FrontEndDevelopment,
    Integration = item.Integration,
    Testing = item.Testing,
    // 关联实体按需赋值，比如仅设置外键Id或完整导航属性
    IdNavigation = item.IdNavigation
}).ToList();

// 批量添加并保存
_context.Qeustions.AddRange(questionEntities);
_context.SaveChanges();

方案2：修复原foreach写法 #

确保每次循环创建新的实体实例：

foreach (var item in questions)
{
    var newQuestion = new Qeustions();
    // 复制所有需要的属性值
    newQuestion.FrontEndDevelopment = item.FrontEndDevelopment;
    newQuestion.ArchitectureDesignAndPlanning = item.ArchitectureDesignAndPlanning;
    newQuestion.InternalMeetings = item.InternalMeetings;
    newQuestion.ClientMeetings = item.ClientMeetings;
    newQuestion.Respondent = item.Respondent;
    newQuestion.EmailsPhoneSkypeCalls = item.EmailsPhoneSkypeCalls;
    newQuestion.Research = item.Research;
    newQuestion.DbDesign = item.DbDesign;
    newQuestion.BackEndDevelopment = item.BackEndDevelopment;
    newQuestion.Integration = item.Integration;
    newQuestion.Testing = item.Testing;

    _context.Qeustions.Add(newQuestion);
}
_context.SaveChanges();

方案3：AutoMapper简化映射（属性较多时推荐） #

通过AutoMapper自动完成同类型属性映射：

1. 安装依赖包：AutoMapper 和 AutoMapper.Extensions.Microsoft.DependencyInjection
2. 配置映射：

var mapperConfig = new MapperConfiguration(cfg =>
{
    cfg.CreateMap<Qeustions, Qeustions>(); // 同类型自动映射所有同名属性
});
var mapper = mapperConfig.CreateMapper();

3. 生成实体集合并添加：

var questionEntities = questions.Select(item => mapper.Map<Qeustions>(item)).ToList();
_context.Qeustions.AddRange(questionEntities);
_context.SaveChanges();

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