title: Select the whole table using linq to Sql Except condition
body: <p>I am using linq to sql query to compare the result from two different tables. Say for example that my first table as got Id &amp; Email columns and my 2nd table as got Email column alone. How do I use linq - Intersect/Except condition to select everything from the first table (including Id column) but not in the 2nd table.</p>
  
  <p>I am using the linq query as shown below:</p>
  
  <pre><code>var result = table1.Select(t =&gt; t.Email).Except(table2);
  </code></pre>
  
  <p>The query works fine but the problem is, I can't get the Id values from the result unless I write another foreach loop.</p>
  
  <p>eg:</p>
  
  <pre><code>foreach(var email in result) { table1.Where(t =&gt; t.Email.Equals(email)); }
  </code></pre>
  
  <p>Can someone suggest me how to get the whole table in my 1st query itself please?</p>