title: Possible to use the Repository Pattern + Stored Procedures ? Should / can they return IQueryable?
body: <p>I'm a big fan of using the <code>Repository pattern</code> to return <code>IQueryable&lt;T&gt;</code> objects. I then let my services layer determine what does what (eg. filter by XXX, order by YYY, project into ABCD, etc).</p>
  
  <p>But I've got some hardcore DB stuff, so I've got it all wrapped up into a <code>Stored Procedure</code>. Works fine. I know EF can execute stored procs .. but I'm not sure how this fits into a Repository Pattern data layer.</p>
  
  <p><em>Does anyone have any examples / suggestions</em>? Do i let the repository method execute the stored procedure, and then i return the result (eg. <code>ICollection&lt;Foo&gt; as AsQueryable</code> .. so the service layer then just queries on that result?</p>