http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Add/Delete in many-to-many relationship Thu, 21 May 2026 21:28:23 -700 Wed, 17 Feb 2010 16:22:44 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1647 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=1647&PID=6219#6219 Author: GregD
Subject: 1647
Posted: 17-Feb-2010 at 4:22pm

It depends upon whether your linking table has a payload or not.  In NorthwindIB, the EmployeeTerritory has a payload and therefore the Entity Framework exposes the EmployeeTerritory linking entity explicitly in the model, and models two 1-to-many associations: Employee->EmployeeTerritory and Territory->EmployeeTerritory. If I understand what you're saying, you wrote a custom property in Employee to return the collection of related Territories. So you'll need another method somewhere that, given a Territory and an Employee, will create a new EmployeeTerritory entity to link them.

If your linking entity has no payload, then EF creates the many-to-many property for you on each entity, and then the Add() and Remove() methods on the collections of related entities will cause the new linking entity to get created behind the scenes.

Note that there's also an EmployeeTerritoryNoPayload table in NorthwindIB. If you use that instead of EmployeeTerritory you can see how the EF behaves when the linking entity has no payload.
]]> Wed, 17 Feb 2010 16:22:44 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1647&PID=6219#6219 http://www.ideablade.com/forum/forum_posts.asp?TID=1647&PID=6215#6215 Author: mit
Subject: 1647
Posted: 16-Feb-2010 at 11:59pm

Hi,

I have a many-to-many relationship similar with the one you have in Many-To-Many Associations in the Entity Framework pdf, for example Employee and Territory and the link table EmployeeTerritory. As explain in the pdf I created a property in Employee class and get the associated territories. So, I need to expose the Territories list in a grid and to add and delete entities to/from that grid.

Can you tell me how can I add a new Territory entity to the Employee and how can I delete it? I tried to just create a new Territory with EntityManager.CreateEntity<Territory>() and to just add it to the Territories list, but it's not working.

Thanks,

Mit]]> Tue, 16 Feb 2010 23:59:58 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1647&PID=6215#6215