I'm generating persistent classes for an existing database using the reverse mapper. I have tables that are indirectly linked to other tables, sometimes through 3 - 4 layers of joins.
Here's an example:
- Client table
- Department table, with fk to Client
- Group table, with fk to Department
- Employee table
- Group- Employee joiner table
What is the best way to go about adding a property to the Client persistent class that exposes all Employees? Is that typically something that you would code yourself? Or is it a configuration point I need to be aware of in the reverse mapper?