c#, Linq, Sql
-
i need to convert sql expression to linq expression, here is my sql code. select a1.Exam_No,a1.Name,a1.Total_Mark,COUNT (a2.Total_Mark)Total_Rank From Table1 a1, Table1 a2 where a1.Total_Mark < a2.Total_Mark or (a1.Total_Mark = a2.Total_Mark and a1.Name = a2.Name) GROUP BY a1.Name, a1.Exam_No, a1.Total_Mark ORDER BY a1.Total_Mark DESC, a1.Name DESC, a1.Exam_No;
-
i need to convert sql expression to linq expression, here is my sql code. select a1.Exam_No,a1.Name,a1.Total_Mark,COUNT (a2.Total_Mark)Total_Rank From Table1 a1, Table1 a2 where a1.Total_Mark < a2.Total_Mark or (a1.Total_Mark = a2.Total_Mark and a1.Name = a2.Name) GROUP BY a1.Name, a1.Exam_No, a1.Total_Mark ORDER BY a1.Total_Mark DESC, a1.Name DESC, a1.Exam_No;
[LINQ to SQL | Microsoft Docs](https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/)
"(I) am amazed to see myself here rather than there ... now rather than then". ― Blaise Pascal