Print Page | Close Window

Saving many-to-many relationship

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=2841
Printed Date: 03-Apr-2025 at 8:59am


Topic: Saving many-to-many relationship
Posted By: CJBriers
Subject: Saving many-to-many relationship
Date Posted: 22-Jul-2011 at 7:38am
Let's say we have a many-to-many relationship between Person and Pet entities (with no payload).  When adding an existing Pet entity to a Person and saving the Person entity:

aPerson.Pets.Add(aPet);
EM.Instance.SaveChangesAsync(new [] {aPerson}); //we're using singleton pattern

This causes a duplicate (same data, different ID) aPet entity to be saved to the DB.  

However, if I do this:

aPerson.Pets.Add(aPet);
EM.Instance.SaveChangesAsync(); 

No duplicate entry is saved to the DB.  Due to the nature of our application, I really prefer saving only the aPerson entity and not the Pet entities. Any way to do this?


Replies:
Posted By: sbelini
Date Posted: 22-Jul-2011 at 8:39am
Hi CJBriers,

This is a bug that has been fixed.

DevForce 6.1.2 will have the fix and will be available early in August.

Silvio.


Print Page | Close Window