In ASP.NET MVC if you want to do it without any third party(Facebook, Google+), Simply you can do it from database by just matching username and password.
But if you want to do it by third party, You can use OAuth functionality by doing that you need to take help of third party account's like Facebook, Google+ etc.