Is it possible to Prefetch multiple tree graphs: For ex: If i have CustId = 1 and 2 and i would like to prefetch all the orders and all details of the above Ids at 1 time. Thanks.

netLearner wrote:

Is it possible to Prefetch multiple tree graphs: For ex: If i have CustId = 1 and 2 and i would like to prefetch all the orders and all details of the above Ids at 1 time. Thanks.

Yes. Just specify a Prefetch path starting with customer, then add the order node to the subpath and the order details to that node's subpath. You can also fetch multiple branched trees.

IPrefetchPath path = new PrefetchPath((int)EntityType.CustomerEntity); path.Add(CustomerEntity.PrefetchPathOrders).SubPath.Add(OrderEntity.PrefetchPathOrderDetails);

Frans Is it possible to prefetch 2 unrelated collections. For Ex: If i have a table1 and tabl2 which are unrelated and i would like to get both of the collections at 1 time instead of: t1.GetMulti(null); t2.GetMulti(null);

Is there a way. Thanks.

No, and a prefetch path is not saving any database activity in that case, as it would also come down to just 2 collection fetches Prefetch paths are for a graph with a single type as root (which can be one or more instances).