title: How can you handle an IN sub-query with LINQ to SQL?
body: <p>I'm a bit stuck on this. Basically I want to do something like the following SQL query in LINQ to SQL:</p>
  <pre><code>SELECT f.* 
  FROM Foo f
  WHERE f.FooId IN (
      SELECT fb.FooId
      FROM FooBar fb
      WHERE fb.BarId = 1000
  )
  </code></pre>
  <p>Any help would be gratefully received.</p>