读书人

把下列SQL转换成Lamda表达式解决方案

发布时间: 2012-06-07 15:05:14 作者: rapoo

把下列SQL转换成Lamda表达式

SQL code
SELECT Level, COUNT(Level), COUNT(Level) / (SELECT COUNT(*) FROM Player) FROM Player Group By Level


这句SQL如何转化,简化些也可以的

[解决办法]
from p in CTX.Player
group p by p.Level
into g
select new{
Level=g.Key,
Count=g.Count(),
ACount=g.Count()/CTX.Player.Count()
}

读书人网 >asp.net

热点推荐