Entity Framework won't save relations

Question

Hi

I have the following situation:

role.Permissions.Add(permission);
objectContext.SaveChanges();

When I now take a look in the relations table Roles_Permissions the newly added permission to the role is not present. It only saves the new relation when I dispose the object context. Am I doing something wrong or does a call to SaveChanges doesn't save changes on relationship sets?

Answer 1

It sounds like you are using a transaction.

The changes made are not visible outside the transaction scope untill the transaction is committed.

And the transaction scope is not being committed until the object context is disposed.

Answer 2

Just check whether they are in the same objectContext.

Answer 3

You can ensure that your permission entity is known to your object context by executing the following line of code:

objectContext.AddObject("Permissions", permission);