EntityFramework update Entity with values of another?

Question

I have a JSON string and I am deserlizing it into a EF entitiy.

Report result = js.Deserialize<Report>(json);

I am trying to update the entity in my context with the same ID to have the values of my deserlized one.

var reportToUpdate    _entities.Reports.Single(x => x.Id == result.Id)

I want to do something like this

reportToUpdate = set all values to the values from result
context.SaveChanges();

How can I do this?

I would like to avoid doing something like this:

report.param1 = result.param1
report.param3 = result.param3
report.param3 = result.param3

because there are about 50 properties on this entity.

Erik Funkenbusch · Accepted Answer · 2013-08-31 06:17:44Z

9

This should work for you.

context.Reports.Entry(reportToUpdate).CurrentValues.SetValues(result);
context.SaveChanges();

Be aware that SetValues does not follow navigational properties or related objects, only complex/simple properties of the entity itself.

answered Aug 31, 2013 at 6:17

Erik Funkenbusch

93.7k29 gold badges201 silver badges292 bronze badges

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

2 Comments

OzBob Over a year ago

With this method be sure to set the Key/Id of 'result' to that of 'reportToUpdate'. if 'result' has an Id=0 then it will throw an exception.

Brent Over a year ago

shouldn't that be context.Entry(reportToUpdate).CurrentValues.SetValues(result); That is contexts track the entry's, not the DBSets

Nilesh · Accepted Answer · 2013-08-31 06:26:17Z

1

If you already populated the entity model, then you just need to do attach the entity

Try something like this.

_context.Reports.Attach(result);
_context.Entry(result).State= EntityState.Modified;

follow this link for more details.

answered Aug 31, 2013 at 6:26

Nilesh

2,7015 gold badges23 silver badges35 bronze badges

1 Comment

Kyle Over a year ago

I tried this and I get an error that it already has one with the same ID. This 'new' one deserialized from json was an 'edit' to one already in the database.

Collectives™ on Stack Overflow

EntityFramework update Entity with values of another?

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related