title: Selecting first 100 records using Linq
body: <p>How can I return first 100 records using Linq?</p>
  
  <p>I have a table with 40million records.</p>
  
  <p>This code works, but it's slow, because will return all values before filter:</p>
  
  <pre><code>var values = (from e in dataContext.table_sample
                where e.x == 1
                select e)
               .Take(100);
  </code></pre>
  
  <p>Is there a way to return filtered? Like T-SQL TOP clause?</p>