title: Updating just one column value using LINQ
body: <p>Suppose I have the ID of a column in a table and I want to increment one of it's column values by 1. How should I go about this. </p>
  
  <p>This is what I already have. 
  Table has 3 properties, (id, category, value) </p>
  
  <pre><code>var col1= db.columns.Where(w =&gt; w.category.Equals("Cars"));
  </code></pre>
  
  <p>I want to increment the value in the table which has category "Cars" by 1. 
  What is the LINQ Query for this. </p>
  
  <p>A similar question may have been asked before but no answer I have seen seems satisfactory enough. </p>