entity framework inserting a many-to-many relationship between two existing objects while updating
        Posted  
        
            by redbluegreen
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by redbluegreen
        
        
        
        Published on 2010-03-11T20:51:14Z
        Indexed on 
            2010/03/11
            20:54 UTC
        
        
        Read the original article
        Hit count: 413
        
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.
© Stack Overflow or respective owner