How to get Single Value From Database through Entity Framework

Question

I have a table that represent userInfo. My requirement is get last value of table as userID. Table structure is

-------------------------------------
userID  |  username  |  password  
-------------------------------------

I use MYsql as database and userID is auto-increment.

I try this code but it not working in my controller

var userID = db.users.Max().userID;

user3559349 · Accepted Answer · 2014-10-25 04:33:45Z

2

Try

var userID = db.users.OrderByDescending(u => u.userID).Select(u => u.userID).FirstOrDefault();

answered Oct 25, 2014 at 4:33

user3559349

Sign up to request clarification or add additional context in comments.

Comments

Omar.Alani · Accepted Answer · 2014-10-25 09:34:28Z

0

Your request should be :

var userId = db.Users.Max(u => u.userID);

answered Oct 25, 2014 at 9:34

Omar.Alani

4,1302 gold badges23 silver badges33 bronze badges