LINQ Pivot with dynamic columns
I'm trying to create a Pivot using LINQ with dynamic columns. I have created a Pivot in SQL Server where you do not know which columns are going to get used. But don't know how to transfer 开发者_开发技巧that into LINQ. Does anyone have links for me to get started on?
Cheers
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)
});
this is the answer from David B in this url
精彩评论