title: Entity Framework 4: Best practices in searching?
body: <p>I am developing a ASP.NET MVC 3 Application with EF4. I have about 50,000 entities and I'm querying them through LINQ to find what matches best with the given search criteria. There are multiple search criterion (up to about 12) and these are matcheon a step by step basis.</p>
  
  <p>Ex: 50,000 students</p>
  
  <ol>
  <li><p>Get the students within the age range -> A</p></li>
  <li><p>From A, get the students who are male -> B</p></li>
  <li>From B, get students who are enrolled to course CS101 -> C</li>
  </ol>
  
  <p>What's the best way to achieve this?</p>