Home > DeveloperSection > Forums > Entity framework inserting a many-to-many relationship between two existing objects while updating
Chintoo Semi

Total Post:135

Points:947
Posted on    September-28-2013 4:02 AM

 ADO.Net ADO.Net 
Ratings:


 1 Reply(s)
 954  View(s)
Rate this:
I'm trying to do this:
using(var context = new SampleEntities())
{
     User user = select a user from database;
 
     //Update user's properties
     user.Username = ...
     user.Website = ...
 
     //Add a role
     Role role = select a role from  database  
     //trying to insert into table UserRoles which has columns (UserID, RoleID)  
     user.Roles.Add(role); 
 
     //Apply property changes
     context.ApplyPropertyChanges("Users", user);
     context.SaveChanges();
}

However, I get an exception telling me that "The existing object in the ObjectContext is in the Added state" and can't "ApplyPropertyChanges". If "ApplyPropertyChanges()" is removed, it adds a User.

What orders should these methods be called? I don't need to do them separately right?

Thanks.



Pravesh Singh
Pravesh Singh

Total Post:101

Points:709
Posted on    September-28-2013 6:36 AM

Hey Chintoo!

It doesn't look to me like your User object is detached, so you shouldn't need to call ApplyPropertyChanges().


Modified On Sep-28-2013 06:37:42 AM

Don't want to miss updates? Please click the below button!

Follow MindStick