title: linq-to-sql: Stored procedures cannot be used inside queries
body: <p>This fails on VS2010 RC LINQ-to-SQL with the InvalidOperationException "Stored procedures cannot be used inside queries.":</p>
  
  <pre><code>var foo = (from a in aTable 
      from b in this.SomeStoredProcedure()
      where a.Id == b.Id
      select b.Id);
  </code></pre>
  
  <p>SomeStoredProcedure is a SQL procedure which returns a table. 'join' also appears to fail. Any thoughts why?</p>