I have an entity as follows.
ID Name Rank School 1 A Lawrence 2 B 1 Lawrence 3 C 2 Lawrence
I need to fetch the details of student in a particular school(Lawrence) who has highest rank. In this example ID 2 is the desired output.
My linq query is:
var result = SchoolDetails.Where(x=>x.School == "Lawrence").Max(y=>y.Rank).SingleOrDefault();
I get a compliation message saying that "int? doesnt contain a definition for SingleOrDefault"
I cannot change the datatype of Rank column to make it non nullable since it is a production code. So, given this situation how can I fetch a record with highest rank?