linq的group by一个例子

[原问题转自]http://topic.csdn.net/u/20120118/14/14bba2f0-1a60-4c6c-a211-fcb6c6da709c.html?12661

有如下表

T_UserConsumeDay

C#代码

            var query = from q in db.T_UserConsumeDay.ToList()
                        group q by q.ConsumeDay.Value.ToString("yyyy-MM") into g
                        orderby g.Key
                        select new
                        {
                            money = g.Sum(r => r.UserConsumeMoney),month = g.Key
                        };

        Dim query = From q In db.T_UserConsumeDay.ToList() _
                    Select r = New With { _
                    .month = q.ConsumeDay.Value.ToString("yyyy-MM"),_
                    .money = q.UserConsumeMoney} _
                    Group r By r.month Into Group = Sum(r.money) _
                    Order By month _
                    Select New With {.totalMoney = Group,.monthConsume = month}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!