你好，我有一个名为Employee的Db2表，所有4列上都有一个主键

| EmployeeID | EmployeeName         |Email                      |     EmpVersion |
| --------   | --------------        | --------                 | -------------- |
|1          |Christoforo Rowcliffe  |crowcliffe0@dion.ne.jp     |0|
|1          |Christoforo Rowcliffe  |crowcliffe0@dion.ne.jp     |1|
|2          |Justus Cockin          |jcockin1@virginia.edu      |1|
|3          |Kellia Shaw            |kshaw2@chron.com           |0|
|3          |Kellia Shaw            |kshaw2@chron.com           |1|
|4          |Dalt Fletcher          |dfletcher3@typepad.com     |1|
|4          |Dalt Fletcher          |dfletcher3@typepad.com     |0|
|5          |Sonnie Stryde          |sstryde4@theatlantic.com   |0|
|6          |Jane Dow               |janedoe@theatlantic.com    |5|

我正在尝试过滤/更新记录，以便如果有任何员工的EmpVersion为0，则我需要检查是否有任何其他员工具有相同的ID，名称，电子邮件和EmpVersion为1，然后删除EmpVersion为0的记录，如果没有找到具有相同ID，名称和电子邮件的员工，则将当前员工记录EmpVersion更新为1
我希望输出类似于

| EmployeeID | EmployeeName         |Email                      |     EmpVersion |
| --------   | --------------        | --------                 | -------------- |
|1          |Christoforo Rowcliffe  |crowcliffe0@dion.ne.jp     |1|
|2          |Justus Cockin          |jcockin1@virginia.edu      |1|
|3          |Kellia Shaw            |kshaw2@chron.com           |1|
|4          |Dalt Fletcher          |dfletcher3@typepad.com     |1|
|5          |Sonnie Stryde          |sstryde4@theatlantic.com   |1|
|6          |Jane Dow               |janedoe@theatlantic.com    |5|

这是我的Linq查询

var employees = _dbContext.Employees.ToList();
        var EnployeesWithVersion0 = employees.Where(a => a.EmpVersion == 0).ToList();
        foreach (var emp in EnployeesWithVersion0)
        {
            try
            {
                if (Employees.Where(x => x.EmployeeID == emp.EmployeeID && 
                                        x.EmployeeName == emp.EmployeeName  &&
                                        x.Email == emp.Email && x.EmpVersion == 1).Any())
                {
                    _dbContext.Entry(emp).State = EntityState.Deleted;
                    _dbContext.SaveChanges();
    
                }
                else
                {
                    try
                    {
                        var innerEmployee = Employees.Where(Employees.Where(x => 
                                           x.EmployeeID == emp.EmployeeID && 
                                           x.EmployeeName == emp.EmployeeName  &&
                                           x.Email == emp.Email && x.EmpVersion ==0).FirstOrDefault();
    
                        _dbContext.EmpVersion = 1;
                        _dbContext.Employees.Update(innerEmployee);
                        _dbContext.SaveChanges();
    
    
                    }
                    catch (Exception ex)
                    {
                        //Log Error
    
                    }
                }
    
            }
            catch (Exception ex)
            {
              //Log Error
            }
         return employees;
       }

但是我得到了错误。更新条目时出错。有关详细信息，请查看内部异常。错误[23505] [IBM][DB2/NT 64] SQL 0803 N INSERT语句、UPDATE语句或DELETE语句导致的外键更新中的一个或多个值无效，因为主键唯一约束或唯一索引标识为1约束表dbo。雇员具有重复的索引键值。”有人对此有意见吗？