EF Core跟踪冲突：同一Country实例引发嵌套对象更新异常

我正在开发应用学习C#/.NET，实体结构如下：

public class StoreChain
{
    public int Id { get; set; }
    public string StoreName { get; set; } = null!;
    public int CreationYear { get; set; }
    public ICollection<StoreLocation> StoreLocations { get; set; } = new List<StoreLocation>();
}

public class StoreLocation
{
    public int Id { get; set; }
    public string Description { get; set; } = null!;
    public Address Address { get; set; } = null!;
    public StoreChain StoreChain { get; set; } = null!;
}

public class Address
{
    public int Id { get; set; }
    public int StreetNumber { get; set; }
    public string StreetName { get; set; }
    public string? Coordinates { get; set; }
    public string City { get; set; } = null!;
    public string Territory  { get; set; } = null!;
    public Country Country { get; set; } = null!;
}

public class Country
{
    public int Id { get; set; }
    public string CountryName { get; set; } = null!;
    public string CountryAbbreviation { get; set; } = null!;
}

EF相关操作代码：

public StoreChain? UpdateLocations(int Id, ICollection<StoreLocation> StoreLocations)
{
    var storeChain = GetStoreChainById(Id);

    if (storeChain == null)
    {
        return null;
    }

    storeChain.StoreLocations = StoreLocations;

    _context.StoreChain.Update(storeChain);
    var success = _context.SaveChanges() > 0;

    return success ? storeChain : null;
}

public StoreChain? GetStoreChainById(int Id)
{
    var storeChain = _context.StoreChain.Where(sc => sc.Id == Id)
                          .FirstOrDefault();

    return storeChain;
}

当尝试为指定StoreChain添加多个位于同一Country的StoreLocation并持久化时，抛出异常：
The instance of entity type 'Country' cannot be tracked because another instance with the key value '{Id}' is already being tracked

我知道EF上下文无法同时跟踪同一键值的多个实体实例，但找不到该场景的明确解决方案，求帮助。

原因分析 #

传入的StoreLocations集合中，多个Address引用了不同实例但ID相同的Country对象。EF上下文在处理Update操作时，会尝试跟踪这些Country实例，但发现已有同ID的实例被跟踪，因此抛出冲突异常。

方案1：复用上下文已跟踪的Country实例 #

在将StoreLocations赋值给StoreChain之前，先从上下文获取对应ID的Country，替换所有Address中的Country为这个已跟踪的实例：

public StoreChain? UpdateLocations(int Id, ICollection<StoreLocation> StoreLocations)
{
    var storeChain = GetStoreChainById(Id);

    if (storeChain == null)
    {
        return null;
    }

    // 提取所有唯一的Country ID
    var countryIds = StoreLocations.Select(sl => sl.Address.Country.Id).Distinct();
    // 从上下文获取这些Country的已跟踪实例
    var existingCountries = _context.Country.Where(c => countryIds.Contains(c.Id)).ToList();

    // 替换每个Address中的Country为已跟踪实例
    foreach (var location in StoreLocations)
    {
        var existingCountry = existingCountries.First(c => c.Id == location.Address.Country.Id);
        location.Address.Country = existingCountry;
    }

    storeChain.StoreLocations = StoreLocations;
    _context.StoreChain.Update(storeChain);
    var success = _context.SaveChanges() > 0;

    return success ? storeChain : null;
}

方案2：手动管理Country的跟踪状态 #

如果确定传入的Country数据没有变化，可以将它们标记为Unchanged，避免EF尝试跟踪新实例：

public StoreChain? UpdateLocations(int Id, ICollection<StoreLocation> StoreLocations)
{
    var storeChain = GetStoreChainById(Id);

    if (storeChain == null)
    {
        return null;
    }

    // 处理每个Country的跟踪状态
    foreach (var location in StoreLocations)
    {
        var country = location.Address.Country;
        var entry = _context.Entry(country);
        if (entry.State == EntityState.Detached)
        {
            // 如果未被跟踪，直接附加并标记为Unchanged
            _context.Country.Attach(country);
            entry.State = EntityState.Unchanged;
        }
        // 如果已被跟踪，无需处理
    }

    storeChain.StoreLocations = StoreLocations;
    _context.StoreChain.Update(storeChain);
    var success = _context.SaveChanges() > 0;

    return success ? storeChain : null;
}

方案3：优化查询与导航属性加载 #

如果StoreChain原本就关联了StoreLocation，可以先加载现有导航属性，再逐个添加新的StoreLocation（而非直接替换整个集合），同时复用现有上下文的实例：

public StoreChain? UpdateLocations(int Id, ICollection<StoreLocation> newStoreLocations)
{
    // 加载StoreChain时Include关联的StoreLocations和相关导航属性
    var storeChain = _context.StoreChain
                          .Include(sc => sc.StoreLocations)
                              .ThenInclude(sl => sl.Address)
                                  .ThenInclude(a => a.Country)
                          .FirstOrDefault(sc => sc.Id == Id);

    if (storeChain == null)
    {
        return null;
    }

    // 清空现有位置（根据业务需求选择保留或替换）
    storeChain.StoreLocations.Clear();

    foreach (var newLocation in newStoreLocations)
    {
        // 复用上下文已有的Country实例
        var existingCountry = _context.Country.Find(newLocation.Address.Country.Id);
        if (existingCountry != null)
        {
            newLocation.Address.Country = existingCountry;
        }
        // 设置关联的StoreChain
        newLocation.StoreChain = storeChain;
        storeChain.StoreLocations.Add(newLocation);
    }

    // 无需调用Update，因为上下文已跟踪storeChain及其关联对象
    var success = _context.SaveChanges() > 0;

    return success ? storeChain : null;
}

注意事项 #

• 避免在同一上下文操作中创建多个同ID的实体实例，尽量复用上下文已加载或附加的实例。
• 对于不需要修改的关联实体（如Country这类基础数据），优先标记为Unchanged或直接使用上下文已跟踪的实例，减少跟踪冲突。

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