首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > .NET >

帮忙看看.

2012-01-19 
帮忙看看.在线等!select UserId as id,count(Style) as numberfrom Awhere Style1006group by UserIdorde

帮忙看看.在线等!
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);

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

热点排行