title: Use linq to generate direct update without select
body: <p>G'day everyone.</p>
  
  <p>I'm still learning LINQ so forgive me if this is naive.  When you're dealing with SQL directly, you can generate update commands with conditionals, without running a select statement.</p>
  
  <p>When I work with linq I seem to follow the pattern of:</p>
  
  <ol>
  <li>Select entities</li>
  <li>Modify entities</li>
  <li>Submit changes</li>
  </ol>
  
  <p>What I want to do is a direct update using linq and deferred execution.  Is it possible that the actual execution occurs directly at the SQL without any data being transmitted up to the client?</p>
  
  <pre><code>DataContext dc = new DataContext
  
  var q = from product in dc.Products
          where product.Type = 1
          set product.Count = 0
  
  dc.SubmitChanges
  </code></pre>
  
  <p>So in essence LINQ has all the information it needs WITHOUT using a select to generate an update command. It would run the SQL:</p>
  
  <pre><code>Update Products Set Count = 0 Where Type = 1
  </code></pre>
  
  <p>Does a keyword like "set" exist in LINQ?</p>