title: Entity Framework Update without reading
body: <p>Is there a way to update a single table / entity without having to read the entity first into a list.
  This is the sql I am trying to achieve.</p>
  
  <p><strong>Update table set col1 = Case col2 When 0 then 1 else 0 end</strong>
  this updates roughly 500,000 records under a second</p>
  
  <p>I do not want to do</p>
  
  <pre><code> List&lt;table&gt; updRecs = Context.tables.toList();
   for each
   {
    if(col1 == 0)
    col2 = true 
    else
    col2 = false
   }
  </code></pre>
  
  <p>Context.SaveChanges(); </p>
  
  <p>above is very slow roughly 4 minutes.</p>