CODEWITHSUNDEEP
c#asp.netentity-frameworklinq-to-entities
black sensei
black sensei

Reputation: 6678

How to select a row(object) based on max of a field Entity Framework 4.1

am trying to get a row (object) based on the max of RollNumber which is a long Datatype field. i expect it to return a null object in case there isn't any so i used SingleorDefault.But it seems my query is all wrong(work in progress on linq here). here is the query:

SchoolContextExpress db = new SchoolContextExpress();
        Profile profile = db.Profiles.Where(p => p.RollNumber == db.Profiles.Max(r=>r.RollNumber)).SingleOrDefault();

thanks for reading this.

Upvotes: 8

Views: 11123

Answers (2)

Roy Pun
Roy Pun

Reputation: 513

Another way to do beside the first answer:

Profile profile = db.Profiles.OrderByDescending(p => p.RollNumber).FirstOrDefault();

Upvotes: 3

Carl Sharman
Carl Sharman

Reputation: 4845

To work with empty RollNumber...

Profile profile = db.Profiles.Where(p => p.RollNumber !=0 &&  p.RollNumber == db.Profiles.Max(r=>r.RollNumber)).SingleOrDefault();

Or you may want to consider...

Profile profile = db.Profiles.Where(p => p.RollNumber == db.Profiles.Where(p1 => p1.RollNumber != 0).Max(r=>r.RollNumber)).SingleOrDefault();

Upvotes: 11

Related Questions