title: Lambda expression Linq-to-SQL get from record 5 to 10
body: <p>I have been trying to get the following:</p>
  
  <p>I have a table with 20 elements in it. I'm trying to write a method that gets a number of records, with some kind of an offset.</p>
  
  <p>For example: I would like to get 5 elements, starting from the 6th one... which means I'd like to have record nr 6,7,8,9 and 10.</p>
  
  <p>Those numbers are not a column or id in the table! I would like to sort the table in a specific way with the result id's get shuffled.</p>
  
  <p>This is my query so far:</p>
  
  <pre><code>project1_category[] categories = db.project1_categories.Select(c =&gt; c)
                                                         .OrderBy(c =&gt; c.Category)
                                                         .ToArray();
  </code></pre>
  
  <p>Any ideas?</p>
  
  <p>Thanks in advance!</p>