EF Core 添加实体时出现重复跟踪错误的排查求助

在EF Core中向DbContext添加OrderTask实体时触发以下错误：

'The instance of entity type 'OrderTask' cannot be tracked because another instance with the key value '{Id: 1}' is already being tracked. When attaching existing entities, ensure that only one entity instance with a given key value is attached.'

实际业务数据中并无Id=1的重复实体，通过分组查询未检测到重复，显式配置主键也无法解决问题，以下为错误原因分析及调试建议。

相关代码 #

数据库表定义 #

CREATE TABLE "Tasks" (
    "Id"    INTEGER NOT NULL,
    "Description"   TEXT NOT NULL,
    CONSTRAINT "PK_Tasks" PRIMARY KEY("Id" AUTOINCREMENT)
);

实体类 #

public class OrderTask : BaseEntity<int>
{
    public string Description { get; set; }
    public ICollection<Machine> Machines { get; set; }
}

public class BaseEntity<T> where T : struct
{
    public T Id { get; set; }
}

数据适配层代码 #

public async Task AddOrUpdateTasks()
{
    using var cn = new SqlConnection(_cn);
    await cn.OpenAsync();
    var cmd = new SqlCommand();
    cmd.CommandType = System.Data.CommandType.StoredProcedure;
    cmd.CommandText = "usp_Task_Sel_All";
    cmd.Connection = cn;

    using var dr = await cmd.ExecuteReaderAsync();
    while (await dr.ReadAsync())
        _orderContext.Tasks.Add(new OrderTask() { Id = (int)dr["TaskNumber"], Description = (string)dr["TaskDescription"] });


    await _orderContext.SaveChangesAsync();
}

测试方法 #

public async Task EFWorkcenterTest()
{
    var orderContext = new OrderContext();
    orderContext.Database.EnsureDeleted();
    orderContext.Database.EnsureCreated();

    var adapter = new Adapter(orderContext);
    await adapter.AddOrUpdateTasks();
}

已尝试的排查操作 #

1. 分组查询检测重复实体，结果为空：

var dup = _orderContext.Tasks.GroupBy(x => x.Id)
              .Where(g => g.Count() > 1)
              .Select(y => y.Key)
              .ToList();

2. 显式配置实体主键，问题未解决：

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<OrderTask>()
        .HasKey(x => x.Id);          
}

错误原因分析 #

1. 存储过程返回重复数据：数据库表无重复，但存储过程usp_Task_Sel_All可能返回多条Id=1的记录。分组查询未检测到重复，是因为_orderContext.Tasks仅包含未被跟踪的实体，而Add操作后EF Core的跟踪队列中已存在重复实体。
2. DbContext跟踪冲突：测试方法中EnsureCreated可能自动初始化了数据，或之前的操作已让DbContext跟踪了Id=1的实体，再次Add时触发跟踪逻辑冲突。
3. 主键映射不匹配：数据库中Id为自增字段，但实体手动赋值Id，EF Core未正确识别字段生成规则，导致跟踪逻辑混乱。

调试建议 #

• 验证存储过程返回结果：在Add操作前打印所有返回的TaskNumber，确认是否存在重复Id：

  while (await dr.ReadAsync())
  {
      var taskId = (int)dr["TaskNumber"];
      Console.WriteLine($"读取到TaskId: {taskId}"); // 查看输出是否有重复
      _orderContext.Tasks.Add(new OrderTask() { Id = taskId, Description = (string)dr["TaskDescription"] });
  }
  

• 查看DbContext跟踪实体：在SaveChangesAsync前检查所有被跟踪的OrderTask实体：

  var trackedTasks = _orderContext.ChangeTracker.Entries<OrderTask>().ToList();
  foreach (var entry in trackedTasks)
  {
      Console.WriteLine($"被跟踪的Task Id: {entry.Entity.Id}, 状态: {entry.State}");
  }
  

• 改用AddOrUpdate逻辑：避免直接Add，先判断实体是否存在再执行新增或更新：

  while (await dr.ReadAsync())
  {
      var taskId = (int)dr["TaskNumber"];
      var existingTask = await _orderContext.Tasks.FindAsync(taskId);
      if (existingTask == null)
      {
          _orderContext.Tasks.Add(new OrderTask() { Id = taskId, Description = (string)dr["TaskDescription"] });
      }
      else
      {
          existingTask.Description = (string)dr["TaskDescription"];
      }
  }
  

• 修正主键生成配置：明确告知EF Core主键的生成规则，解决手动赋值与自增的冲突：

  protected override void OnModelCreating(ModelBuilder modelBuilder)
  {
      modelBuilder.Entity<OrderTask>()
          .HasKey(x => x.Id)
          .Property(x => x.Id)
          .ValueGeneratedOnAdd(); // 允许手动赋值覆盖自增
  }
  

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