Consider this:

customer-orders-ordertype all related to each other:

How can i fetch this the best way to get : 1 customer - several orders - 1 ordertype per order

I just came to the following

adapter.fetchentitycollection(orders,customer.GetRelationInfoOrders())

How do I get the ordertype

Richard

You need to "get" the difference between relations and pre-fetch paths. Pre-fetch paths are for fetching graphs of related entites (this is what you are trying to do). Relations are for adding additional tables in to the query to allow you to filter on data in related tables (effectivly they generate SQL joins)

You need something like

var pfp = new PreFetchPath2();
pfp.Add(CustomerEntity.PrefetchPathOrders).SubType.Add(OrderEntity.PrefetchPathOrderType);
adapter.FetchEntityCollection(customers,pfp) //check correct overload...!

Matt

Thanks, Matt