风轻云淡

-------生活没有抱怨,只有自己的不努力,当才华撑不起梦想与野心,不断学习是你唯一的选择。没有伞的孩子必须努力奔跑...

导航

Attaching an entity of type 'xxx' failed because another entity of the same type already has the same primary key value

 Attaching an entity of type 'xxx' failed because another entity of the same type already has the same primary key value. This can happen when using the Attach() method or setting the state of an entity to 'Unchanged' or 'Modified' if any entities in the graph have conflicting > key values. This may be because some entities are new and have not yet received database-generated key values. In this case use the 'Add' method or the 'Added' entity state to track the graph and then set the state of non-new entities to 'Unchanged' or 'Modified' as appropriate.

----------------------------------解决办法--------------------------

       public bool Update(T Entity)
        {
            T _local = _DbContextHandle.Set<T>().Local.FirstOrDefault(a => a.id == Entity.id);
            if (_local == null)
            {
                _DbContextHandle.Set<T>().Attach(Entity);
                _DbContextHandle.Entry<T>(Entity).State = EntityState.Modified;
            }
            else
            {
                _DbContextHandle.Entry(_local).CurrentValues.SetValues(Entity);
                _DbContextHandle.Entry(_local).State = EntityState.Modified;
            }
            return _DbContextHandle.SaveChanges() > 0;
            //以下代码可用#####
            //T t = _DbContextHandle.Set<T>().Local.FirstOrDefault(a => a.id == Entity.id);
            //if (t != null)
            //{//手动删除已存在的实体
            //    //_DbContextHandle.Set<T>().Attach(Entity);
            //    _DbContextHandle.Entry<T>(t).State = EntityState.Detached;
            //}
            //_DbContextHandle.Set<T>().Attach(Entity);
            //var aaa = _DbContextHandle.Entry<T>(Entity);
            //aaa.State = EntityState.Modified;
            //return _DbContextHandle.SaveChanges() > 0;
        }

posted on 2020-05-28 13:40  淡然→笑  阅读(1793)  评论(0编辑  收藏  举报