RID UserID CourseID SemID SubjectID UnitID ScoredMarks TotalMarks No_Attempts CreatedDate ModifiedDate 1 1021 109 3000 2006 100 30 100 1 2019-02-12 00:00:00.000 NULL 2 1021 109 3000 2006 101 40 100 1 2019-02-18 00:00:00.000 NULL 3 1021 109 3000 2006 102 85 100 1 2019-02-19 00:00:00.000 NULL 4 1022 109 3000 2006 101 80 100 1 2019-02-19 00:00:00.000 NULL 5 1022 109 3000 2006 100 75 100 1 2019-02-19 00:00:00.000 NULL
var scoreCard = dbcontext.Stu_Result .Where(u => u.CourseID == CourseID && u.SemID == SemID && u.SubjectID == SubjectID) .ToList() .GroupBy(u => u.UserID) .OrderByDescending(grp=>grp.Average(u => u.ScoredMarks)) .Select((grp, i) =>new { UserId = grp.Key, Rank = i+1, AverageScore = grp.Average(u => u.ScoredMarks) }) .ToList();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)