What's the right way to do associations?

[JonL]

Also worth a read. Sooner or later you will find yourself at the same point.

One-to-many-to-many-to-many performance

Let’s say I have the following relationships for datatypes A, B, C and D. A: List of B B: List of C, Single A C: List of D, Single B D: Single B, Single C If I request A will it also retrieve data in cascade from C and D? Or will it stop at B data?