In my model I've got a bunch of domain objects. Now I'm having a problem when trying to update a User-object. The User has a foreignkey relation to the Role object. When I update the User-object without changeing the foreignkey value (FkRoleId) it all works fine. But when I change the role for the current user I want to update I get the error:
A referential integrity constraint violation occurred: The property values that define the referential constraints are not consistent between principal and dependent objects in the relationship.
Here's how I update my user-object:
public void Update(User user)
{
using (var context = new DBEntities())
{
context.Entry(user).State = System.Data.EntityState.Modified;
context.SaveChanges();
}
}
How can I update my user-object without getting this exception? There must be a way for chaning the foreignkey value for mappen the user to another role.
Here's my domain classes in this case:
public partial class User
{
public User()
{
this.Advertisers = new HashSet<Advertiser>();
this.Cases = new HashSet<Case>();
this.Materials = new HashSet<Material>();
}
public int PkId { get; set; }
public int FkRoleId { get; set; }
public string Name { get; set; }
public string Email { get; set; }
public string Password { get; set; }
public System.DateTime Created { get; set; }
public bool Active { get; set; }
public virtual ICollection<Advertiser> Advertisers { get; set; }
public virtual ICollection<Case> Cases { get; set; }
public virtual ICollection<Material> Materials { get; set; }
public virtual Role Role { get; set; }
}
public partial class Role
{
public Role()
{
this.Users = new HashSet<User>();
}
public int PkId { get; set; }
public string Name { get; set; }
public string Description { get; set; }
public virtual ICollection<User> Users { get; set; }
}
To quote your comment:
However; if I set the navigation property user.Role to null it works just fine. But, is this the recommended way of working?
Yes, in this case it is.
You must keep in mind that you enter a new context with a detached object user
(including the reference to user.Role
). By setting the state to Modified
you attach the object user
together with the related user.Role
to this new context.
Because your are using a foreign key association - that means that the foreign key is represented by a property FkRoleId
in the model class - the relationship is described in two ways: By the navigation property user.Role
and by the scalar property user.FkRoleId
. If these are not consistent - i.e. user.Role.PkId != user.FkRoleId
- EF doesn't know which one describes the correct relationship and throws the exception you have.
If you set user.Role
to null
EF will consider the user.FkRoleId
alone as the property that describes the relationship between user and role and the ambiguity that was causing the exception is removed.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With