linq的group by一个例子

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

有如下表

T_UserConsumeDay

UserConsumeMoney	ConsumeDay
20.0000	2011-12-1
23.0100	2011-11-1
25.0120	2012-1-1
28.0000	2011-12-2

我需要按月统计UserConsumeMoney的总额,预计结果如下

totalMoney	monthConsume
23.0100	2011-11
48.0000	2011-12
25.0120	2012-01

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
                        };

VB.NET代码 //vb.net代码比较麻烦,可能是我水平有限,如果有高人知道,请指点.

        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}