How do I convert a DBQuery<> (or ObjectQuery<>) to a non-collection primitive type (ie: int, string)

var lastitem = Contacts
.OrderByDescending(c => c.ContactID)
.Take(1).Select(p=>p.ContactID);

lastitem is even though a single item returns a DBQuery<Int32>

is there a way to convert it to just a pure Int32?

Thanks for the help!

A开发者_如何学编程LSO:

is there a better way to do this? Basically, I'm trying to get an Int32 type from ContactID from the very last item inside the database

You want .First() (throws if empty) or .FirstOrDefault() (returns 0 if empty, or null if you add .Cast<int?() first):

int lastitem = Contacts.OrderByDescending(c => c.ContactID)
                       .Select(c => c.ContactID)
                       .First();