Update a record in Entity Framework Core

Question

I have an existing record from database that I have retrieved using Entity Framework:

 MyDataObject myExistingObject= _dbContext.data
   .Where(s => s.Id == myId).FirstOrDefaultAsync();

Externally, I have received another MyDataObject newDataObjectForSameRow that contains updated information for myExistingObject - all fields except Primary Key, that is initially set to 0 in the newDataObjectForSameRow.

How can I instruct Entity Framework "replace the row that has currently myExistingObject by newDataObjectForSameRow, however keeping the same Primary Key"?

Make changes to myExistingObject .. then, _dbContext.Save() — Jawad
– Jawad, Commented Feb 18, 2020 at 22:33
@Jawad but can I somehow re-attach Entity Framework to completely new object? — onkami
– onkami, Commented Feb 18, 2020 at 22:35
You should not keep two instanced of the same entity tracked at the same time. Either one of the object is your DTO then you need to map the properties from A to B (you could use automapper for this) or you should not have instantiated the second object in the first place. If you provide us with some code we can help better. — Nando
– Nando, Commented Feb 18, 2020 at 22:54

Ryan · Accepted Answer · 2020-02-19 06:42:12Z

2

Try to use below code:

newDataObjectForSameRow.Id = myId;
MyDataObject myExistingObject = _dbContext.data.Where(s => s.Id == myId).FirstOrDefaultAsync();
_dbContext.Entry(myExistingObject).CurrentValues.SetValues(newDataObjectForSameRow);
_dbContext.SaveChanges();

answered Feb 19, 2020 at 6:42

Ryan

20.3k10 gold badges44 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

Update a record in Entity Framework Core

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related