SQL语句转成Linq，高手帮忙解决方案

SQL语句转成Linq，高手帮忙SQL codeselect sum(UserConsumeMoney) as totalMoney, convert(nvarchar(7), Co

SQL语句转成Linq，高手帮忙

SQL code

select sum(UserConsumeMoney) as totalMoney, convert(nvarchar(7), ConsumeDay,120) as monthConsume from T_UserConsumeDaygroup by convert(nvarchar(7), ConsumeDay,120)

[解决办法]

探讨
SQL code

select sum(UserConsumeMoney) as totalMoney, convert(nvarchar(7), ConsumeDay,120)
as monthConsume from T_UserConsumeDay
group by convert(nvarchar(7), ConsumeDay,120)