Sum of items in a collection

by

You can do LINQ to Objects and the use LINQ to calculate the totals:

decimal sumLineTotal = (from od in orderdetailscollection
select od.LineTotal).Sum();

You can also use lambda-expressions to do this, which is a bit “cleaner”.

decimal sumLineTotal = orderdetailscollection.Sum(od => od.LineTotal);

You can then hook this up to your Order-class like this if you want:

Public Partial Class Order {
  ...
  Public Decimal LineTotal {
    get {
      return orderdetailscollection.Sum(od => od.LineTotal);
    }
  }
}

More Related Contents:

  1. Sum multidimensional array over dimensions [closed]
  2. LINQ: Distinct values
  3. Entity Framework: There is already an open DataReader associated with this Command
  4. LINQ-to-SQL vs stored procedures? [closed]
  5. Entity framework linq query Include() multiple children entities
  6. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  7. How to view LINQ Generated SQL statements?
  8. How to view LINQ Generated SQL statements?
  9. LINQ across multiple databases
  10. Convert String to Int in EF 4.0
  11. System.LINQ.Dynamic: Select(” new (…)”) into a List (or any other enumerable collection of )
  12. LINQ Join with Multiple Conditions in On Clause
  13. Standard Deviation in LINQ
  14. How can I reject all changes in a Linq to SQL’s DataContext?
  15. How To Project a Line Number Into Linq Query Results
  16. Calculate difference from previous item with LINQ
  17. LINQ with SQLite (linqtosql)
  18. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  19. How to create a dynamic LINQ join extension method
  20. Linq query with nullable sum
  21. EF 4: Removing child object from collection does not delete it – why?
  22. How to dynamically add OR operator to WHERE clause in LINQ
  23. Is there a pattern using Linq to dynamically create a filter?
  24. Linq to SQL how to do “where [column] in (list of values)”
  25. Greater Than Condition in Linq Join
  26. How do I write this cross apply query in LINQ-to-SQL?
  27. Can’t make GroupJoin work. NavigationExpandingExpressionVisitor exception
  28. OrderBy descending in Lambda expression?
  29. LINQ: How to convert the nested hierarchical object to flatten object
  30. Fun (?) with Linq Expressions in extension methods

Leave a Comment