读书人

SQL话语转成Linq高手帮忙

发布时间: 2012-12-28 10:29:05 作者: rapoo

SQL语句转成Linq,高手帮忙


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)

var query=from t in T_UserConsumeDay
group t by t.ConsumeDay.ToString("yyyy-MM") into g
orderby g.Key
select new
{
totalMoney=g.Sum(m=>m.UserConsumeMoney),
monthConsume=g.Key
};

读书人网 >.NET

热点推荐