开发者

LINQ Pivot with dynamic columns

开发者 https://www.devze.com 2023-02-25 05:47 出处:网络
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 开发者_开

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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号