- Totaling Duplicate Records
- 1 John Doe $100.50
- 2 John Doe $51.23
- Total Amount:$151.73
- 3 Jane Doe $100.01
- 4 Jim Johns $94.05
- 4 Jim Johns $5.00
- Total Amount:$99.05
- var duplicates = from p in db.People
- join p by p.Name into g
- select new{g.Name, Sum => g.Sum(g.Price)};