I've got a question how to set up relations in a good manner in Umbraco.

Set you have a datamodel like a project, that project has multiple newsitems, multiple comments, those comments has also a user and that user has a favorite color.

The way normaly i work is i set up a good datamodel but in Umbraco you don't have a "real" datamodel so i made the doctypes and make the relation with the ultimate picker. But how do you query things like that? Now i made alot of foreach loops to tie everything together but that can't be the right way.

Do you guys have any experience query'en data like that, how do i set up this that the performance is still ok?

thx advance for any answers!