读书人

帮忙看看.

发布时间: 2012-01-19 00:22:27 作者: rapoo

帮忙看看.在线等!
select UserId as id,count(Style) as number from A where Style=1006 group by UserId order by number desc

此句sql 帮忙翻译成Linq形式 . 谢过!

[解决办法]

C# code
var result = A.Where(c => c.Style == 1006)    .GroupBy(g => g.UserId)    .Select(e => new { id = e.Key, number = e.Count() })    .OrderByDescending(o => o.number);
[解决办法]
C# code
var query=A.Where(w=>w.Style==1006)           .GroupBy(g => g.UserId)           .Select(s => new { id = s.Key, number = s.Count()})           .OrderByDescending(o => o.number);
[解决办法]
探讨
引用:
C# code
var result = A.Where(c => c.Style == 1006)
.GroupBy(g => g.UserId)
.Select(e => new { id = e.Key, number = e.Count() })
.OrderByDescending(o => o.number);

我如何取得这个对象的某……

读书人网 >.NET

热点推荐