title: Cross Join in Entity framework Lambda Expressions
body: <p>How can I do the following join in EF?
  Tables have no relation with each other, no foreign keys.</p>
  
  <pre><code>Select t1.ID,  t1.firstname, t2.ID,t2.name from MY_TEST_TABLE1 t1, MY_TEST_TABLE2 t2
  where t1.firstname = t2.name
  </code></pre>