帮忙看看.在线等！

[Assassin_]

select UserId as id,count(Style) as number from A where Style=1006 group by UserId order by number desc

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

[老毕]

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);

[claymore1114]

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);

[Assassin_]

[Quote=引用 1 楼 abbey 的回复:]
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);
[/Quote]
谢谢!那我去和取得 返回的属性呢?

[Assassin_]

[Quote=引用 1 楼 abbey 的回复:]
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);
[/Quote]
我如何取得这个对象的某一条数据 或者是属性呢

[白玉寒天]

[Quote=引用 4 楼 yumen3501 的回复:]
引用 1 楼 abbey 的回复:
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);

我如何取得这个对象的某……
[/Quote]

返回的是List<>类型的值，可以用foreach遍历，至于记录数，可以用count属性

[Assassin_]

谢谢!.问题已解决