title: GroupBy then Take in LINQ to Entities?
body: <p>Let's say I have the following items:</p>
  
  <pre><code>ID      Category        Name
  
  1       Fruit           Banana
  2       Car             Mescedes
  3       Fruit           Blackberry
  4       Fruit           Mango
  5       Car             Lexus
  6       Fruit           Melon
  7       Car             BMW
  8       Car             Toyota
  </code></pre>
  
  <p>I want to group them into <code>Category</code> and take only the first 3 items of each <code>Category</code>. Is it possible?</p>
  
  <p>I expected the output:</p>
  
  <pre><code>ID        Category        Name
  
  1        Fruit           Banana
  3        Fruit           Blackberry
  4        Fruit           Mango
  2        Car             Mescedes
  5        Car             Lexus
  7        Car             BMW
  </code></pre>
  
  <p>Any helps would be appreciated!</p>