var result = from p in table group p by p.Name into g select new { Name = g.Key, TotalAmount = g.Sum(p => p.Amount) };
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)