LINQ to SQL and a running total on ordered results

by

Using closures and anonymous method:

List<Item> myList = FetchDataFromDatabase();

decimal currentTotal = 0;
var query = myList
               .OrderBy(i => i.Date)
               .Select(i => 
                           {
                             currentTotal += i.Amount;
                             return new { 
                                            Date = i.Date, 
                                            Amount = i.Amount, 
                                            RunningTotal = currentTotal 
                                        };
                           }
                      );
foreach (var item in query)
{
    //do with item
}

More Related Contents:

  1. property remove from the list
  2. Returning IEnumerable vs. IQueryable
  3. Difference Between Select and SelectMany
  4. Return anonymous type results?
  5. LINQ – Left Join, Group By, and Count
  6. When should I dispose of a data context
  7. Sorting a list using Lambda/Linq to objects
  8. Linq select objects in list where exists IN (A,B,C)
  9. How to return anonymous type from c# method that uses LINQ to SQL [duplicate]
  10. LINQ: combining join and group by
  11. Convert Linq Query Result to Dictionary
  12. LINQ Where Ignore Accentuation and Case
  13. Get table-data from table-name in LINQ DataContext
  14. DISTINCT() and ORDERBY issue
  15. Find() vs. Where().FirstOrDefault()
  16. Linq query with nullable sum
  17. C# Linq where clause as a variable
  18. LINQ identity function
  19. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  20. LINQ Expression to return Property value?
  21. How to make LINQ execute a (SQL) LIKE range search
  22. Will using LINQ to SQL help prevent SQL injection
  23. Code equivalent to the ‘let’ keyword in chained LINQ extension method calls
  24. Get sum of two columns in one LINQ query
  25. Last and LastOrDefault not supported
  26. Linq “Could not translate expression… into SQL and could not treat it as a local expression.”
  27. Linq OrderBy against specific values
  28. Is Injection Possible through Dynamic LINQ?
  29. If Else in LINQ
  30. C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

Leave a Comment