title: Entity, dealing with large number of records (> 35 mlns)
body: <p>We have a rather large set of related tables with over 35 million related records each. I need to create a couple of WCF methods that would query the database with some parameters (data ranges, type codes, etc.) and return related results sets (from 10 to 10,000 records). </p>
  
  <p>The company is standardized on EF 4.0 but is open to 4.X. I might be able to make argument to migrate to 5.0 but it's less likely. </p>
  
  <p>What’s the best approach to deal with such a large number of records using Entity? Should I create a set of stored procs and call them from Entity or there is something I can do within Entity?</p>
  
  <p>I do not have any control over the databases so I cannot split the tables or create some materialized views or partitioned tables. </p>
  
  <p>Any input/idea/suggestion is greatly appreciated.</p>