title: How to get data from 2 tables without joining them?
body: <p>I need to write on linq2sql analogue of the following query:</p>
  
  <pre><code>SELECT A.Field1, B.Field2 FROM tableA A, tableB B
  </code></pre>
  
  <p>How can I do that?</p>
  
  <p>I would start from something like this</p>
  
  <pre><code>from a in DBContext.tableA, 
  ...
  select new {Field1=a.Field1, Field2=b.Field2};
  </code></pre>
  
  <p>but what should I write instead of "..."? How to mention 2nd table to be linked?</p>
  
  <p>Thanks.</p>
  
  <p>P.S. Hope I am clear</p>