title: Chain LINQ IQueryable, and end with Stored Procedure
body: <p>I'm chaining search criteria in my application through IQueryable extension methods, e.g.:</p>
  
  <pre><code>public static IQueryable&lt;Fish&gt; AtAge (this IQueryable&lt;Fish&gt; fish, Int32 age)
  { 
      return fish.Where(f =&gt; f.Age == age);
  }
  </code></pre>
  
  <p>However, I also have a full text search stored procedure:</p>
  
  <pre><code>CREATE PROCEDURE [dbo].[Fishes_FullTextSearch]
  @searchtext nvarchar(4000),
  @limitcount int
  AS
  SELECT Fishes.* FROM Fishes
    INNER JOIN CONTAINSTABLE(Fishes, *, @searchtext, @limitcount)
    AS KEY_TBL ON Fishes.Id = KEY_TBL.[KEY]
    ORDER BY KEY_TBL.[Rank]
  </code></pre>
  
  <p>The stored procedure obviously doesn't return IQueryable, however, is it possible to somehow limit the result set for the stored procedure using IQueryable's?</p>
  
  <p>I'm envisioning something like .AtAge(5).AboveWeight(100).Fishes_FulltextSearch("abc").</p>
  
  <p>In this case, the fulltext search should execute on a smaller subset of my Fishes table (narrowed by Age and Weight).</p>
  
  <p>Is something like this possible? Sample code?</p>