title: Can I consolidate the results of my Linq to SQL query?
body: <p>Can I consolidate my Linq to Sql query results as part of the query? For example the following query would return list A below. I want my list to be consolidated like list B below.</p>
  
  <pre><code>        IEnumerable&lt;JoinClass&gt; points =
                           from c in db.Users2
                           join e in db.Categories on c.Id_Users2 equals e.FK_Users2
                           join f in db.Programs on e.Id_Category equals f.FK_Categories
                           join g in db.Points on f.Id_Programs equals g.FK_Programs
                           where c.EEID == UserEEIDCast
                           orderby g.EntryDate ascending
                           select new JoinClass
                           {
                               Category = e.Category,
                               Programs = f.Programs,
                               Points = g.Points,
                               EEID = c.EEID,
                               EntryDate = g.EntryDate,
                               Name = c.Name
  
  
  
          return View(points);
  </code></pre>
  
  <p><strong>List A</strong></p>
  
  <p>Name Program Points</p>
  
  <hr>
  
  <p>Jim Running 10</p>
  
  <p>Jim Running 3</p>
  
  <p>Jim Walking 7</p>
  
  <p>Jim Walking 4</p>
  
  <p>Bob Running 2
  Bob Running 1</p>
  
  <p><strong>List B</strong></p>
  
  <p>Name Program Points</p>
  
  <hr>
  
  <p>Jim Running 13</p>
  
  <p>Jim Walking 11</p>
  
  <p>Bob Running 3</p>