Entity Framework Update DbContext

Question

I have a Repository project like this.

https://github.com/tugberkugurlu/GenericRepository/tree/master/src

I have a method.

public void Edit(TEntity entity)
{
   _dbContext.SetAsModified(entity);
}


public void SetAsAdded<TEntity>(TEntity entity) where TEntity : class
{
   DbEntityEntry dbEntityEntry = GetDbEntityEntrySafely(entity);
   dbEntityEntry.State = EntityState.Added;
}

But I am getting while update record. I am getting sometimes this error.

Attaching an entity of type 'TP.Model' 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.

Have you seen this? stackoverflow.com/questions/23201907/… — Mohammed Gadi
– Mohammed Gadi, Commented Nov 6, 2017 at 8:28
I read over and over, but I don't understand there is a problem. — Caner
– Caner, Commented Nov 6, 2017 at 8:31
Debug your context dbset Local collection... if it already contains an entity with your id, then your code might fail. However, you didn't show enough of your code, so we can,t be sure what the problem is. — grek40
– grek40, Commented Nov 6, 2017 at 8:42
No, you need to add how you use the code, not just how the repository is designed. Because the way the repository is resigned means, that you will get this error if you use it in the wrong way. — grek40
– grek40, Commented Nov 6, 2017 at 9:13

Caner · Accepted Answer · 2017-11-08 08:40:34Z

0

I solved the problem like this. I checked the first columns. Afterwards, I did something like this.

_dbSet = dbContext.DbSet<TEntity>();

The rest is cake.

_dbSet.Attach(entity);
                DbEntityEntry entry = _dbContext.Entry(entity);
                foreach (var proprty in entry.OriginalValues.PropertyNames)
                {
                    var Current = entry.CurrentValues.GetValue<object>(proprty);
                    var New = entry.GetDatabaseValues().GetValue<object>(proprty);

                    if (Current != null)
                    {
                        if (!object.Equals(New, Current))
                        {
                            entry.Property(proprty).IsModified = true;
                        }
                    }
                }

answered Nov 8, 2017 at 8:40

Caner

8831 gold badge14 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework Update DbContext

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related