ASP.NET Core 6中AutoMapper映射关联实体触发唯一键冲突错误

你在AutoMapper配置中直接通过_ctx.ClassEmployee.Find()获取ClassEmployee并赋值给Employee的导航属性时，EF Core会将该实体标记为Added状态，尝试将其插入数据库，但这条ClassEmployee记录已经存在，因此触发唯一键约束冲突。

方案1：仅映射外键，依赖EF自动关联导航属性 #

EF Core会根据外键FKIdClassEmployee自动关联对应的导航属性，无需手动查询赋值。修改AutoMapper配置，移除导航属性的映射逻辑：

public class EmployeeProfile : Profile
{
    public EmployeeProfile()
    {
        EmployeeDTOToEmployee();
    }

    private void EmployeeDTOToEmployee()
    {
        CreateMap<EmployeeDTO, Employee>()
            .ForMember(dest => dest.SerialNumber, opt => opt.MapFrom(d => d.SerialNumber))
            .ForMember(dest => dest.Active, opt => opt.MapFrom(d => d.Active))
            .ForMember(dest => dest.FKIdClassEmployee, opt => opt.MapFrom(d => d.FKIdClassEmployee));
        // 移除ClassEmployee导航属性的映射配置
    }
}

方案2：标记查询到的ClassEmployee为已存在状态 #

如果必须映射导航属性，需要明确告知EF Core该实体已存在，不需要插入。修改映射逻辑：

.ForMember(dest => dest.ClassEmployee, opt => opt.MapFrom(src => 
{
    if (src.FKIdClassEmployee == null) return null;
    var classEmp = _ctx.ClassEmployee.Find(src.FKIdClassEmployee);
    if (classEmp != null)
    {
        // 将实体标记为Unchanged，避免EF尝试插入
        _ctx.Entry(classEmp).State = EntityState.Unchanged;
    }
    return classEmp;
}));

方案3：不在AutoMapper中依赖DbContext（推荐） #

AutoMapper Profile的职责是处理对象映射，注入DbContext会违反单一职责原则。建议在控制器/服务层中单独处理导航属性关联：

1. 修改AutoMapper Profile，移除DbContext注入和导航属性映射：

public class EmployeeProfile : Profile
{
    public EmployeeProfile()
    {
        EmployeeDTOToEmployee();
    }

    private void EmployeeDTOToEmployee()
    {
        CreateMap<EmployeeDTO, Employee>()
            .ForMember(dest => dest.SerialNumber, opt => opt.MapFrom(d => d.SerialNumber))
            .ForMember(dest => dest.Active, opt => opt.MapFrom(d => d.Active))
            .ForMember(dest => dest.FKIdClassEmployee, opt => opt.MapFrom(d => d.FKIdClassEmployee));
    }
}

2. 在Create方法中手动关联导航属性：

public async Task<IActionResult> Create(EmployeeDTO dto)
{
    var employee = _mapper.Map<Employee>(dto);
    if (employee.FKIdClassEmployee.HasValue)
    {
        var classEmp = await _ctx.ClassEmployee.FindAsync(employee.FKIdClassEmployee.Value);
        if (classEmp != null)
        {
            _ctx.Attach(classEmp); // 标记实体为已存在
            employee.ClassEmployee = classEmp;
        }
    }
    _ctx.Employees.Add(employee);
    await _ctx.SaveChangesAsync();
    return Ok();
}

优先使用方案1，仅映射外键让EF自动处理关联，这种方式最简洁，也能避免不必要的数据库操作和实体状态管理问题。

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