How do I get the max ID with Linq to Entity?

Question

I have a table User which has an identity column UserID, now what is the correct Linq to Entity line of code that would return me the max UserID?

I've tried

        using (MyDBEntities db = new MyDBEntities())
        {
            var User = db.Users.Last();
            // or
            var User = db.Users.Max();

            return user.UserID;
        }

but Last and Max don't seem to be supported.

Any ideas?

Thank you,

Ray.

Answer 1

Try with

db.Users.OrderByDescending(u => u.UserId).FirstOrDefault()

Answer 2

try this

int intIdt = db.Users.Max(u => u.UserId);

Answer 3

Hi,

and.. if i want to add a restriction? I mean, supose that I want the max UserID where UserAge is more than 21, how can i do this?

I've try:

Users user = bd.Users.Where(u=> u.UserAge > 21).Max(u => u.UserID);

but it doesn't work... :(

Answer 4

Thank you so much!!

Answer 5

NisaPrieto

Users user = bd.Users.Where(u=> u.UserAge > 21).Max(u => u.UserID); will not work because MAX returns the same type of variable that the field is so in this case is an INT not an User object.