title: DataTables - configurable query
body: <p>I have collected data from two different sources, for instance: from a online resource and from a local database. The results from these sources is each stored in their own <code>System.Data.DataTable</code> object(flat structure).</p>
  
  <p>I want to be able to query these sources with a join-query that i can configure in App.Config. How can this be accomplished?</p>
  
  <p><code>DataTable</code> <code>dtPublicCompanyBlacklist</code> contains the following columns:</p>
  
  <pre><code>id 
  name
  </code></pre>
  
  <p><code>DataTable</code> <code>dtMyCompanyCustomerSource</code> contains the following columns:</p>
  
  <pre><code>id 
  salesTotal
  e-mail
  </code></pre>
  
  <p>I want to be able to write something like following (as <code>string</code>):</p>
  
  <pre><code>select a.name, b.salesTotal, b.e-mail 
  from dtPublicCompanyBlacklist a, dtMyCompanyCustomerSource  b 
  where a.id = b.id
  </code></pre>
  
  <p>The users of the application should be able to modify the query without having to recompile the sourcecode. I have not found that Linq can be used like this.</p>