我试图以下列方式执行EF更新,但继续收到此错误:
只有当属性的当前值为null时,才能设置EntityKey属性.
- using (hydraEntities db = new hydraEntities())
- {
- YouUser = db.youusers.Include("address").Include("entity").Include("youusercontacts.contact").Include("youuserlogins").Include("youusernotes.note").Include("youusernotes.youuser.entity").Where( yu => yu.YOUUserId.Equals(YOUUserId)).First();
- }
- YouUser.entity.FirstName = txtFirstName.Text;
- YouUser.entity.LastName = txtLastName.Text;
- YouUser.address.AddressLine1 = txtAddressLine1.Text;
- YouUser.address.AddressLine2 = txtAddressLine2.Text;
- YouUser.address.City = txtCity.Text;
- YouUser.address.State = ddlState.SelectedValue;
- YouUser.address.Zipcode = txtZipcode.Text;
- using (hydraEntities db = new hydraEntities())
- {
- db.youusers.AddObject(YouUser);
- db.ObjectStateManager.ChangeObjectState(YouUser,System.Data.EntityState.Modified);
- db.SaveChanges();
- }
非常感谢我如何解决这个问题并执行上述声明.
解决方法
在此方案中不要使用AddObject.它用于插入新实体,但您正在更新现有实体.改为使用Attach:
- using (hydraEntities db = new hydraEntities())
- {
- db.youusers.Attach(YouUser);
- db.ObjectStateManager.ChangeObjectState(YouUser,System.Data.EntityState.Modified);
- db.SaveChanges();
- }