Can I exclude an update on a object in entity framework?

Question

I have an object in my entity model ( it is a view in the db getting data over a linked server). Anyways, when I call contex.savechanges(), it updates everything that is changed in the object model. I don't want to update that certain object. Is there a way to exclude that object from updating? I haven't been able to find any properties or methods that would work.

Thanks for any suggestions. Brian

See [this answer](http://stackoverflow.com/a/1162162/1370166). You really want to not track this object. — TylerOhlsen, Oct 29 '12 at 21:29
I tried to use this, however there wasn't a method listed for it in the shortcut menu. Not sure if I have the correct version of entity framework or not. — Loganj99, Oct 31 '12 at 11:45

D Stanley · Answer 1 · 2012-10-31T13:30:37.580

1

Set the object's state to Unchanged:

_context.Entry(myObject).State = EntityState.Unchanged;

MSDN docs for:

DbContext.Entry method

EntityState property

edited Oct 31 '12 at 13:30

answered Oct 29 '12 at 21:12

D Stanley

149,601
11
178
240

Sorry, but this is a hack that may cause issues later in code. You are effectively lying to the framework to fool it into thinking no update is needed. – TylerOhlsen Oct 29 '12 at 21:30
I couldn't find this option under the methods shortcuts. – Loganj99 Oct 31 '12 at 11:45
What version of EF are you using? – D Stanley Oct 31 '12 at 13:30

score 0 · Answer 2 · answered Oct 31 '12 at 11:47

0

I ended up creating a class to use. Instead of changing things in the entity object, I just populated the object to use in the method. Works like a champ.

answered Oct 31 '12 at 11:47

Loganj99

449
2
9
26

Can I exclude an update on a object in entity framework?

2 Answers2