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 codesimply 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