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

Srikanth Reddy · Answer

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