title: How to do a LINQ Outer Join of a SubTable?
body: <p>I have a data tables with this type of setup.</p>
  
  <p>Table A</p>
  
  <pre><code>AID     AName
  ---------------------
  1       A_Name1
  2       A_Name2
  3       A_Name3
  </code></pre>
  
  <p>Table B</p>
  
  <pre><code>BID     BName
  ---------------------
  10      B_Name1
  20      B_Name2
  30      B_Name3
  </code></pre>
  
  <p>Table C</p>
  
  <pre><code>AID     BID
  ---------------------
  1       10
  2       10
  2       20
  2       30
  3       20
  3       30
  </code></pre>
  
  <p>I want to use LINQ to write a query that for a given ID of A give me the list of B that is not in table C.</p>
  
  <p>So for AID of 1 I want BID of 20 &amp; 30.</p>
  
  <p>For AID of 3 I want BID of 10</p>
  
  <p>For AID of 2 nothing returned anything returned.</p>
  
  <p>I know the SQL would be </p>
  
  <pre><code>SELECT
      B.BID
  FROM B
  LEFT OUTER JOIN C ON C.BID = B.BID AND A.AID = 1 
  -- AID would change based on which I was looking for, 1, 2, or 3
  </code></pre>
  
  <p>What is the LINQ Equivalent? </p>
  
  <p>Please assume I have objects that match the tables of A, B, and C accordingly.</p>