title: Entity framework where, order and group
body: <p>I'm using the following LINQ to select data from a table:</p>
  
  <pre><code>(from m in entity.Results
  where m.Group == 0 ||
  m.Group == 1
  orderby m.Points descending
  select m);
  </code></pre>
  
  <p>This gives me a result of all Users who are in Group 1 or 2. With that i can display the points they have. But this shows me the points they have in Group 1 and Group 2 separately.</p>
  
  <p>How can i group them and display the total points they have? So instead of this (What i have now):</p>
  
  <pre><code>user1 - group1 - 10
  user1 - group2 - 7
  user2 - group1 - 7
  user2 - group2 - 5
  </code></pre>
  
  <p>I want this:</p>
  
  <pre><code>user1 - total: 17
  user2 - total: 12
  </code></pre>
  
  <p>How do i have to adjust my query to get a result set like that?</p>