fork download 
  1. using System; using System.Linq; using System.Collections.Generic;
  2.  
  3. public class Test
  4. {
  5. 	public static void Main()
  6. 	{
  7. 		var result= new List<DebtCreditorRPT>();
  8. 		result.Add(new DebtCreditorRPT() { MemberId = 1, Name = "a", Amount = "12"});
  9. 		result.Add(new DebtCreditorRPT() { MemberId = 2, Name = "b", Amount = "13"});
  10. 		result.Add(new DebtCreditorRPT() { MemberId = 1, Name = "a", Amount = "14"});
  11.  
  12. 		var query = result.GroupBy(i=>i.Name).Select(g => new
  13.         { 
  14.             Name = g.Key,
  15.             Amount = g.Sum(x => double.Parse(x.Amount))
  16.         });
  17.  
  18. 		foreach (var item in query) Console.WriteLine(item);
  19. 	}
  20. }
  21.  
  22. public  class DebtCreditorRPT
  23. {
  24.         public int MemberId { get; set; }
  25.         public string Name { get; set; }
  26.         public string Amount { get; set; }
  27. }
Success #stdin #stdout 0.05s 34056KB
comments (?)
stdin 
Standard input is empty
stdout 
{ Name = a, Amount = 26 }
{ Name = b, Amount = 13 }
https://ideone.com/E9Ngy4
language:
C# (gmcs 5.20.1)
created:
11 years ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!