Thanks for your response. So, ultimately i can write QuerySpec, set up a DynamicList, or even call a stored procedure, but at the end of the day, i need to hand craft the code to map from the result of the query to the object graph.
Could the need to fetch an object and some (or all) of it's related entities and collections within 1 SQL statement generating the required JOINS be part of a future release, or is it by design that this is not implemented?
I am interested to know the reasoning behind it. As a product, I have a lot of respect for the work that has been done, but i am thinking that the need to get an entity and it's related entities/collections from the db in one query must be a common scenario.
Thanks again for your help.