Login verification in MVC

Question

Hai friends,   I am beginner to MVC.   I have created registration.cshtml & login.cshtml.   How to check whether the user is valid user or invalid user?   In asp.net I used as: select count(*) from Users where mailid=" " & password= " " if it returns 0 i simply said user is invalid else valid user.   The same scenerio how to use in MVC with LINQ or Lambda Expression?   Please reply me what type of code I need to write?

Saineshwar Bageri · Answer

Here is LINQ solution.
int userId = (from u in db.Users
where u.mailid == EmailID && u.password = Password
select u.Id).firstOrDefault();
Mark as answer if i solved your issue

Saineshwar Bageri · Answer

i am just storing value which is return from linq expression in this int  userid,
which tell user is exists or not

Sreekanth Reddy · Answer

int userId = (from u in db.Users
where u.mailid == EmailID && u.password = Password
select u.Id).firstOrDefault();
What the userid contains?