在EF6中更新实体会产生主键异常

debugcn 发表于 Dev

回声

当我尝试在EF6中更新此对象时，出现错误，指出有多个实体具有此主键。看着这个数据库，我知道这是不正确的（从我所看到的）。

我需要能够基于发布的对象上的属性之一来更新第二个对象。下面的代码产生错误。我在评论中留下了一些尝试使之起作用的内容。

public async Task<ActionResult> Edit(PricingRule pricingRule)
    {

        if(ModelState.IsValid)
        {
            var currentUser = await serv.UserManager.FindByIdAsync(User.Identity.GetUserId());
            var company = currentUser.Company;
            //var entityRule = serv.PricingService.PricingRules.Get(pricingRule.PricingRuleId);


            //If this is the first rule, set it to the company default
            var rulesCount = company.PricingRules.Count;
            if (rulesCount <= 1 || company.DefaultPricingRule == null)
                pricingRule.DefaultPricingRule = true;


            //Make sure no other rules are marked as default, and update the company with this rule as default
            if (pricingRule.DefaultPricingRule)
            {
                if (company.DefaultPricingRule != null)
                {
                    var oldRule = serv.PricingService.PricingRules.Get(company.DefaultPricingRule.PricingRuleId);
                    oldRule.DefaultPricingRule = false;
                    //serv.PricingService.PricingRules.Update(oldRule);
                }
                company.DefaultPricingRule = pricingRule;
                serv.CoreService.Companies.Update(company);

            }

            serv.PricingService.PricingRules.Update(pricingRule);
            await serv.SaveAllChangesAsync();
            return RedirectToAction("Index");
        }

        return View(pricingRule);
    }

回声

无论是最佳实践还是从技术上讲，这都是我解决问题的方式。

在进行任何其他操作之前，我传入的已编辑对象必须先标记为已修改。我假设这是因为上下文随后可以获取它，并且与此有关的所有其他操作都将在“上下文内”完成。从其他方面来说，我认为如果尝试将新对象附加到company.DefaultPricingRule，它就会尝试添加一个新对象。

public async Task<ActionResult> Edit(PricingRule pricingRule)
    {

        if(ModelState.IsValid)
        {
            serv.PricingService.PricingRules.Update(pricingRule);
            var currentUser = await serv.UserManager.FindByIdAsync(User.Identity.GetUserId());
            var company = currentUser.Company;

            //If this is the first rule, set it to the company default
            var rulesCount = company.PricingRules.Count;
            if (rulesCount <= 1 || company.DefaultPricingRule == null)
                pricingRule.DefaultPricingRule = true;


            //Make sure no other rules are marked as default, and update the company with this rule as default
            if (pricingRule.DefaultPricingRule)
            {
                if (company.DefaultPricingRule != null)
                {
                    var oldRule = serv.PricingService.PricingRules.Get(company.DefaultPricingRule.PricingRuleId);
                    oldRule.DefaultPricingRule = false;
                    serv.PricingService.PricingRules.Update(oldRule);
                }

                company.DefaultPricingRule = pricingRule;
                serv.CoreService.Companies.Update(company);
            }

            await serv.SaveAllChangesAsync();
            return RedirectToAction("Index");
        }

        return View(pricingRule);
    }

如果有人对这是最佳做法还是有更好的方法发表意见，我很乐意提出批评。

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。