日期:2014-05-20  浏览次数:20771 次

SQL语句转成Linq,高手帮忙
SQL code

select sum(UserConsumeMoney) as totalMoney, convert(nvarchar(7), ConsumeDay,120) 
as monthConsume from T_UserConsumeDay
group 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)