DevForce Community Forum : Many-to-many: Just save the linking object??

DevForce Community Forum : Many-to-many: Just save the linking object?? http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Many-to-many: Just save the linking object?? Mon, 13 Apr 2026 17:19:21 -700 Mon, 16 May 2011 00:28:36 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2667 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Many-to-many: Just save the linking object?? : Thanks, that helps me a lot!1)... http://www.ideablade.com/forum/forum_posts.asp?TID=2667&PID=10694#10694 Author: AuerRo
Subject: 2667
Posted: 16-May-2011 at 12:28am

Thanks, that helps me a lot!

1) I absolutely agree, but unfortunately I'm facing clients that would rather undo an edit manually than using a restore-button.

2) That's my way!

Thanks for your help!

Roland

PS: Wouldn't it be a nice feature for a future release to be able to determine if a m2m-relationship changed? It's a bit confusing if I have an EntityManager with changes, but every Entity's EntityState is unchanged.

]]> Mon, 16 May 2011 00:28:36 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2667&PID=10694#10694 Many-to-many: Just save the linking object?? : Hi Roland, Thanks for clarifying. Unfortunately,... http://www.ideablade.com/forum/forum_posts.asp?TID=2667&PID=10659#10659 Author: sbelini
Subject: 2667
Posted: 12-May-2011 at 9:47am

Hi Roland,

Thanks for clarifying.

Unfortunately, in a m2m with no payload, you will not be able to accomplish this.

In this situation, even with a partial save (i.e. SaveChanges(new Entity[] {anEmployee}); or SaveChanges(new Entity[] {aTask}); ) will save the whole Employee-LinkingTable-Task trio.

1) technically, if you manually changed the value back to its original, it would actually be a second change rather than a restore. In this case you will need to compare values to determine if it was a restore or another change. Then again, it won't apply on Navigation properties.

You might also consider using RejectChanges:

myEmployee.EntityAspect.RejectChanges();

2) a m2m with payload will give you the freedom to manipulate the linking table directly.

Silvio.

]]> Thu, 12 May 2011 09:47:49 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2667&PID=10659#10659 Many-to-many: Just save the linking object?? : Hi Silvio! Thanks for the answer.Let... http://www.ideablade.com/forum/forum_posts.asp?TID=2667&PID=10654#10654 Author: AuerRo
Subject: 2667
Posted: 12-May-2011 at 9:11am

Hi Silvio! Thanks for the answer.

Let me clarify the problem by using an example.

I have two entities, Employee and Task, connected m2m without payload; (One Employee can work on many Tasks, on Task can be assigned to many Employees);

If I add or remove a User from Task.Users, how am I able to save that, without saving the Task-Entity itself? Something like SaveChanges(Task.Users); but it seems that this is not possible, or am I wrong?

Questions to your answers of my questions:

1) That's clear. But how do I check if a m2m navigation property changed at all? For example, if i manually restore the collection in the ui to the value it was before the first change, I want the IsDirty-flag to be false. For every dataproperty in an entity, i can take all DataProperties (from EntityAspect.EntityMetadata.DataProperties) and compare property.GetValue(entity, EntityVersion.Original) to property.GetValue(entity, EntityVersion.Proposed);

The problem is, I can't get any EntityVersion with the ListNavigationProperties (EntityAspect.EntityMetadata.ListNavigationProperties), so I can't check if they changed or a change was undone by the user.

2) No question on that. Maybe that would be a solution, just to fake a payload so that I can save the change immediately.

Thanks for your help!

Roland

]]> Thu, 12 May 2011 09:11:50 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2667&PID=10654#10654 Many-to-many: Just save the linking object?? : Hi Roland, Not sure what... http://www.ideablade.com/forum/forum_posts.asp?TID=2667&PID=10648#10648 Author: sbelini
Subject: 2667
Posted: 11-May-2011 at 3:42pm

Hi Roland,

Not sure what you mean by calling SaveChanges() on the linked entity... do you mean calling a partial save?

SaveChanges(new Entity[] {entityToBeSaved});

It that's what you mean, then the linking entity (of a m2m with no payload relation) will also be saved.

Please clarify so I can better understand what you are describing.

Answering your questions:

1) You can add an EventHandler to the CollectionChanged event of the entity's nav property:

employee.Territories.CollectionChanged += new System.Collections.Specialized.NotifyCollectionChangedEventHandler(Territories_CollectionChanged);

2) You won't be able to do that in a m2m with no payload linking table. You could do it if you had a m2m with payload... However, you must be aware that you can only call a partial save on the linking table if both entities already exist in the datasource. Otherwise, you must commit the Added entity(ies) as well. (otherwise you will have an exception due to not resolving all temporary IDs)

Silvio.

Edited by sbelini - 11-May-2011 at 3:43pm]]> Wed, 11 May 2011 15:42:54 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2667&PID=10648#10648 Many-to-many: Just save the linking object?? : Hi,I have a many-to-many relationship... http://www.ideablade.com/forum/forum_posts.asp?TID=2667&PID=10637#10637 Author: AuerRo
Subject: 2667
Posted: 11-May-2011 at 8:27am

Hi,

I have a many-to-many relationship with no payload.

According to this article in the docs, calling SaveChanges() on the linked entity saves the linking object.

In my application I can only save an entity when it is dirty, so the linking object won't be saved, as the entity stays unchanged when a many-to-many-relation is added. Whereas if i call SaveChanges() on the linked entity, every change beside the linking object will also be saved, and that's something i do not want.

In order to solve this, I have two questions:

Is there a way to determine if a m2m-relation is added to an entity? That could change the "is dirty state".
Or: Is there a way to only save the linking object, without saving the entity's changes?

Thanks for any help in advance!

Roland

]]> Wed, 11 May 2011 08:27:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2667&PID=10637#10637