将如下sql语句翻译成linq语句~该如何处理

2012-04-25

将如下sql语句翻译成linq语句~~~~SQL codeSELECT Areate,ColorName,C FROM V AS AWHERE C(SELECT MAX(C)

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

SQL code

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

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

[解决办法]

探讨
SQL code
SELECT Areate,ColorName,C FROM V AS A
WHERE C=(SELECT MAX(C) FROM V WHERE Areate=A.Areate )

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

阅读人气排行