title: How to join a DataTable and a SQL table using LINQ
body: <p>I need to join a <code>DataTable</code> and a SQL table using LINQ. </p>
  
  <p>This is the LINQ query:</p>
  
  <pre><code>from c in db.Staging
  join c1 in tagging on c.RPT_ID equals c1.RPT_ID
  select c
  </code></pre>
  
  <p>However I am getting the following error:</p>
  
  <blockquote>
    <p>System.NotSupportedException: Local sequence cannot be used in LINQ to SQL implementations of query operators except the Contains operator.</p>
  </blockquote>