Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 7th, 2012  |  syntax: None  |  size: 0.38 KB  |  hits: 13  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Linq2Sql: Sum of joined column
  2. class A
  3. {
  4.      //props
  5. }
  6.  
  7. class B
  8. {
  9.     //props
  10.     decimal ValToSum { get; set; }
  11. }
  12.        
  13. IEnumerable<A> myList;
  14. // obtain myList from DataContext
  15.        
  16. myList.Bs.Sum(x => x.ValToSum);
  17.        
  18. myList.SelectMany(x => x.Bs).Sum(x => x.ValToSum);
  19.        
  20. var sum = myList.SelectMany(i => i.Bs).Sum(i => i.ValToSum);
  21.        
  22. var sum = myList.Bs.Select(x => x.ValToSum).Sum();
create a new version of this paste RAW Paste Data