title: How to update a datatable with another datatable?
body: <p>I want to join two datatables using something like this:</p>
  
  <pre><code>update u
  set datatable1.column["state"]= datatable2.column["state"]
  from datatable1 u
      inner join datatable2 s on
          u.column["header"]= s.column["header"]
  </code></pre>
  
  <p>what is the syntax in linq? </p>