Interested in everyone's tactics for creating entities and mappers to handle complex join conditions and complex relationships. If the goal is to have a foundation built ahead of time, then when new joins are required later by programmers, how to accomplish that without having to modify the separate layers you've built? Any sites out there with ideas on handling that? Any way of creating entities on the fly?

What is the general method out there in the dotnet world for handling entities and mappers and complex joins or parent-multiple child scenarios later when the product is in maitenance mode?

What if Codesmith is used to generate the mappers and business entities? you dont' want to run codesmith every time a new relationship is needed down the road and have to modify that layer.

Interested in any ideas and brainstorming anyone is willing to do.