Hi People,

Another very simple question, I am just wondering what the best practise for check if a relation is already defined for a given many to many.

For instance if I have

A -> B <-C

whats the best way of checking before adding a record that an entry tieing table a and C together doesn't already exist?

Thanks Alex

PS I am using the adapter pattern.

For instance if I have

A -> B <-C

whats the best way of checking before adding a record that an entry tieing table a and C together doesn't already exist?

Either try to fetch it from B before adding it. Or use a Unique Key constraint on B (AId & cId), and try to save the new B entity and handle the unique constraint violation exception if found.

Thanks for the fast reply, I might go with fetching it first but I will also add a unique constrait. Just wondered if LLBLgen had a trick up its sleeve as it does for almost everything

Thanks! Alex