title: Temp table in LINQ to Entities
body: <p>I have a table of user ids that is huge.<br>
  I have an array of user ids that I want.<br>
  I have two tables that have a foreign user id key.</p>
  
  <p>What is the best way to get this information performance wise?</p>
  
  <p>Ideally in SQL the final result would be somewhat like this (null values if there is no user ID in one table but not the other):</p>
  
  <pre><code>userid  table1value table2value
  1        null          12
  5        123           null
  </code></pre>