how to remove owin security and login from database in mvc 5

Question

Im having trouble to login from my database in mvc 5 application plz help me to how to login from database in mvc 5 application

Shahbaz Kaware · Answer

im new for mvc i cant understand that

Arunprasath Gajapathi · Answer

simply you can use entity framework insted of ado.net, you can configure your connection string in webconfig file in your mvc project, you dont need those code,simply check the login credentials and redirect to your home page ,if login fails throw the errors using viewbag

Shahbaz Kaware · Answer

same hai connection name

Amit Kumar · Answer

Please check your connection name in webconfig file.

Shahbaz Kaware · Answer

public async Task Login(LoginViewModel model, string returnUrl) { if (!ModelState.IsValid) { return View(model); } // Require the user to have a confirmed email before they can log on. var user = await UserManager.FindByNameAsync(model.Email); if (user != null) { if (!await UserManager.IsEmailConfirmedAsync(user.Id)) { string callbackUrl = await SendEmailConfirmationTokenAsync(user.Id, "Confirm your account-Resend"); ViewBag.errorMessage = "You must have a confirmed email to log on."; return View("Error"); } } // This doesn't count login failures towards account lockout // To enable password failures to trigger account lockout, change to shouldLockout: true var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout: true); switch (result) { case SignInStatus.Success: return RedirectToLocal(returnUrl); case SignInStatus.LockedOut: return View("Lockout"); case SignInStatus.RequiresVerification: return RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe }); case SignInStatus.Failure: default: ModelState.AddModelError("", "Invalid login attempt."); return View(model); } this is my login i want to take the values from my database for logn here is the ado.net code public bool Login(LoginViewModel login) { string constr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; SqlConnection con = new SqlConnection(constr); SqlCommand cmd = new SqlCommand("Login", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Email", login.Email); cmd.Parameters.AddWithValue("@Password", login.Password); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i >= 1) { return true; } else { return false; } } how do i integrate this code to get the login from my database plz help me

Amit Kumar · Answer

Hi Dear, Please use blow links. https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/introduction/creating-a-connection-string

how to remove owin security and login from database in mvc 5

Answers (6)