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?