Hi,
I just noticed today an issue that I hope you can help me with.
I'm using LLBLGen 4.2 and the LLBLGen runtime framework.
Basically I have this entity structure
Payroll
PayAdjustment
PayAddition
PayDeduction
PayAdjustment is a supertype for PayAddition and PayDeduction
Payroll has a 1 to many relationship with PayAddition and PayDeduction.
to make it clear I can navigate like this
payroll.PayAdditions or payroll.PayDeductions
Now, if I delete a PayAddition or PayDeduction individually, the corresponding db row for the supertype PayAdjustment is deleted as well but if for example I delete Payroll, only the corresponding db rows for PayAddition and PayDeduction are deleted, but not the associated row of the supertype PayAdjustment.
What's going on?
The relationships in question have been set with delete CASCADE.
On another note, I did not create a relationship between Payroll and PayAdjustment even though it seemed logical because I wanted to have navigators for PayDeductions and PayAdditions. Probably it Payroll was related directly to PayAdjustment I wouldn't have the issue described above but I wouldn't have the navigators, unless there's a way to get the navigators that I'm not aware of.