Id   UserName Psw   Role
1    ADAM      123   Admin
2    John      456    Hr

public bool Login(LoginCrediential Login)
        {
            var x = (from n in db.LoginCrediential
                    where n.UserName == Login.UserName && n.Password == Login.Password select n).FirstOrDefault();
            if (x != null)return true;
            else return false;  //Here How can i get Roles When UserName & Psw Match