How does one manipulate joins?

Posts   
 
    
Emmanuel
User
Posts: 167
Joined: 13-Jan-2006
# Posted on: 14-Jun-2007 23:45:35   

I can't believe I can't figure out this basic question but...

How does one manipulate joins in llblgen. I'm using the adapter classes in a db editing web app and I have a few lookup tables to which there are m:n relationships via some join tables.

I am persisting edits to an entity that contains "CollectionVia" members but notice that these collections are simply a read-only reflection of the other table's rows. How do I CHANGE the collection?

The only way I can think of is to delete all the records in the join table itself and then add some again to reflect the edited list. However this seems cumbersome and I'm sure LLBLGen has a nice, built-in and better way of doing it.

Emmanuel
User
Posts: 167
Joined: 13-Jan-2006
# Posted on: 15-Jun-2007 00:07:50   

Never mind!

I see that the collection of join table rows pointed to by my entity are, in fact, just the rows that relate to the entity and not ALL rows in the join table (as I first thought). This being the case, I can just edit those items.

Duh.