Lets suppose that you have the typical 3 tables (customer, order and orderitem)

Lets suppose that you have the typical 3 tables (customer, order and orderitem) in a relational database.
The relationship between these tables are the following:
One to many between customer and order
One to many between order and orderitem
Now you define a CDT for the customer entitiy with all its properties (table columns) including the related order entity.
Question:
If you instantiate a specific customer with its CDT the system will return from the database all the related orders and recursively all the related orderitems?
This could be a lot of data and very inefficient.
...

OriginalPostID-100572

OriginalPostID-100572