将如下sql语句翻译成linq语句~~~~

[zhangsuyunpk521]

SELECT Areate,ColorName,C FROM V AS A
WHERE C=(SELECT MAX(C) FROM V WHERE Areate=A.Areate )

翻译成Linq语句，谢谢~~~

[q107770540]

[Quote=引用楼主 的回复:]
SQL code
SELECT Areate,ColorName,C FROM V AS A
WHERE C=(SELECT MAX(C) FROM V WHERE Areate=A.Areate )


翻译成Linq语句，谢谢~~~
[/Quote]

var query= from A in db.V
           where A.C==db.V.Where(x=>x.Areate==A.Areate).Select(x=>x.C).Max()
           select new {A.Areate,A.ColorName,A.C};

[zhangsuyunpk521]

[Quote=引用 1 楼 的回复:]
引用楼主 的回复:
SQL code
SELECT Areate,ColorName,C FROM V AS A
WHERE C=(SELECT MAX(C) FROM V WHERE Areate=A.Areate )


翻译成Linq语句，谢谢~~~

C# code
var query= from A in db.V
where A.C==db.V……
[/Quote]
谢谢，我是这样写的from g in GroupUnion where g.Count == (from gs in GroupUnion where gs.Areate == g.Areate select gs.Count).Max() select new { Areate = g.Areate, ColorName = g.ColorName, Count =g.Count };
不过你的视乎跟简洁~~