title: EF IsModified = false still updating Underlyuing Column
body: <p>I have an entity that is in a Detached state. There are 2 fields on the entity 
  that I DO NOT want to be updated. I am setting their IsModfied to false, but the properties are still updating in SQL SERVER. How can I force these columns not to update SQL SERVER?        </p>
  
  <pre><code>if (Context.Entry(updatedFoo).State == EntityState.Detached)
  {
     var oldEntity = Context.Foo.Find(updatedFoo.FooId);
     Context.Entry(oldEntity).Property(x =&gt; x.createdUserId).IsModified = false;
     Context.Entry(oldEntity).Property(x =&gt; x.createDateTime).IsModified = false;
     Context.Entry(oldEntity).CurrentValues.SetValues(updatedSaving);
     Context.Entry(oldEntity).State = EntityState.Modified;
  }
  </code></pre>
  
  <p>******EDIT*****</p>
  
  <p>Seting an EntityState to modified over-writes all the Property level States that have been previously set. </p>
  
  <p>If you set a state to modified and then set the individual properties on columns you will get the below error</p>
  
  <p><strong>Additional information: Setting IsModified to false for a modified property is not supported</strong></p>