title: Lambda expression to SQL UPDATE statement using C#
body: <p>Is library or code available to create SQL Update statements from lambda expressions?  We would like to use strongly-typed lambda expressions to do updates instead of calling the object before hand, or using strings.  I'm thinking of something like this.</p>
  
  <pre><code>Update&lt;Task&gt;(
      u =&gt; u.UserID = 1, u.TaskCount += 1, //Update
      w =&gt; w.Priority != "High" &amp;&amp; (w.Status != "Complete" || w.Status == null) //Where
  );
  </code></pre>
  
  <p>Which would roughly translate to..</p>
  
  <pre><code>UPDATE Tasks SET UserID = 1, TaskCount = TaskCount + 1
  WHERE Priority &lt;&gt; "High" AND (Status &lt;&gt; "Complete" OR Status = null)
  </code></pre>
  
  <p>I should mention we are currently using the Entity Framework and Postgres.</p>