protected void BtnLoginButton_Click(object sender, EventArgs e) { using (var cadvDBContext = new CADVDbEntities()) { var userData = cadvDBContext.CADV_UserMaster.FirstOrDefault( u => u.Loginpass == txtPassword.Text && u.Loginname.Equals(txtUserName.Text, StringComparison.InvariantCultureIgnoreCase)); if (userData != null) { Session["UserCached"] = userData; Response.Redirect(ConfigurationManager.AppSettings[userData.RoleID.ToString()].ToString()); } else { lbFailureText.Text = "User Name or password is incorrect"; } } }