Is it possible to Pivot data using LINQ?

by

Something like this?

List<CustData> myList = GetCustData();

var query = myList
    .GroupBy(c => c.CustId)
    .Select(g => new {
        CustId = g.Key,
        Jan = g.Where(c => c.OrderDate.Month == 1).Sum(c => c.Qty),
        Feb = g.Where(c => c.OrderDate.Month == 2).Sum(c => c.Qty),
        March = g.Where(c => c.OrderDate.Month == 3).Sum(c => c.Qty)
    });

GroupBy in Linq does not work the same as SQL. In SQL, you get the key and aggregates (row/column shape). In Linq, you get the key and any elements as children of the key (hierarchical shape). To pivot, you must project the hierarchy back into a row/column form of your choosing.

More Related Contents:

  1. Multiple “order by” in LINQ
  2. C# LINQ find duplicates in List
  3. How to filter nested collection Entity Framework objects?
  4. Linq with group by having count
  5. LINQ Partition List into Lists of 8 members [duplicate]
  6. LINQ Between Operator
  7. LINQ OrderBy versus ThenBy
  8. What’s the difference between IQueryable and IEnumerable [duplicate]
  9. Can LINQ be used in PowerShell?
  10. Use LINQ to concatenate multiple rows into single row (CSV property)
  11. Linq-to-entities – Include() method not loading
  12. Rotate – Transposing a List using LINQ C#
  13. PowerShell equivalent of LINQ Any()?
  14. Instantiating a context in LINQ to Entities
  15. conditional include in linq to entities?
  16. LINQ not updating on .SubmitChanges()
  17. Linq To Entities – how to filter on child entities
  18. Expose IQueryable Over WCF Service
  19. The specified type member ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties
  20. Entity Framework, Code First and Full Text Search
  21. How LINQ works internally?
  22. LINQ OrderBy not ordering .. changing nothing .. why?
  23. Simple Linq query has duplicated join against same table?
  24. Multiple WHERE clause in Linq
  25. ASP.NET Core & EntityFramework Core: Left (Outer) Join in Linq
  26. OrderBy descending in Lambda expression?
  27. If condition in LINQ Where clause
  28. Point connectionstring in dbml to app.config
  29. LINQ: How to convert the nested hierarchical object to flatten object
  30. Fun (?) with Linq Expressions in extension methods

Leave a Comment