c# - 使用 SubmitChanges() 时数据库中的字段未更新

Question

我正在尝试使用数据库上下文更新数据库中的 2 个字段

 [HttpPost]
    [ValidateAntiForgeryToken]
    public ActionResult ChangeDefaultUserLockingSetting(int PasswordAttempts, int DefaultLockingTime)
    {
        var defaultAccountSettings = new DefaultAccountSettingsDataContext();
        var defaultLockoutTimeSpam = defaultAccountSettings.DefaultAccountSettings.Where(u=>u.id==1).Select(u=>u.DefaultAccountLockoutTimeSpan).First();
        var maxFailedAccessAttemptsBeforeLockout = defaultAccountSettings.DefaultAccountSettings.Where(u => u.id == 1).Select(u=>u.MaxFailedAccessAttemptsBeforeLockout).First();

        //foreach (int item in defaultLockoutTimeSpam)
        {
            defaultLockoutTimeSpam = DefaultLockingTime;
        }

        maxFailedAccessAttemptsBeforeLockout = DefaultLockingTime;

        defaultAccountSettings.SubmitChanges();


        return View("Index", loadAdministrationViewModel());
    }

我做错了什么？

Answer 1

您需要尝试这段代码。

 [HttpPost]
    [ValidateAntiForgeryToken]
    public ActionResult ChangeDefaultUserLockingSetting(int PasswordAttempts, int DefaultLockingTime)
    {
        var defaultAccountSettings = new DefaultAccountSettingsDataContext();
        var defaultLockoutTimeSpam = defaultAccountSettings.DefaultAccountSettings.Where(u => u.id == 1).FirstOrDefault();
        var maxFailedAccessAttemptsBeforeLockout = defaultAccountSettings.DefaultAccountSettings.Where(u => u.id == 1).FirstOrDefault();

        //foreach (int item in defaultLockoutTimeSpam)
        {
            defaultLockoutTimeSpam.DefaultAccountLockoutTimeSpan = DefaultLockingTime;
        }

        maxFailedAccessAttemptsBeforeLockout.MaxFailedAccessAttemptsBeforeLockout = DefaultLockingTime;

        defaultAccountSettings.SubmitChanges();


        return View("Index", loadAdministrationViewModel());
    }