Add Many-to-Many Entity Framework

Posted by tomcamara on Stack Overflow See other posts from Stack Overflow or by tomcamara
Published on 2012-06-16T02:38:20Z Indexed on 2012/06/16 3:16 UTC
Read the original article Hit count: 141

Filed under:
|
|

I've got a question:

I have 3 tables:

  1. Users
  2. Menu
  3. UserMenu

UserMenu contains IdMenu and IdUser.

In My DataModel Entity Framework 4.0, I'm filling my User Model and filling User.Menu (Menu is Navigation Properties) with an existing Menu of my table Menu.

I have to save User and Save each related menu item in UserMenu table.

I get the following exception:

The ObjectStateManager does not contain an ObjectStateEntry with a reference to an object of type 'SGGED.Model.Menu'.

Code

Users objUser = new Users();

objUser.name = itemUsers.name.Trim();
objUser.email = itemUsers.email.Trim();
objUser.password = Util.HashString("12345");
objUser.effdt = DateTime.Now;

objData.Users.AddObject(objUser);

foreach (var itemMenu in itemUsers.Menu)
{
    objData.ObjectStateManager.ChangeObjectState(itemMenu, EntityState.Unchanged);
}

affRows = objData.SaveChanges();

Whats the way to handle this issue?

Best Regards,

Miltom Camara

© Stack Overflow or respective owner

Related posts about c#

Related posts about ASP.NET