I have a customer table with 2 customers. The linked Orders table has only 1 order. (fresh DB)

When I add a prefetch and select all the customers, I get 2 orders. They are copies of the same order (OrderPK is the same)

So CustomerCollection[0].OrderCollection.Count = 2

I use this code.

IPrefetchPath path = new PrefetchPath((int)EntityType.CustomerEntity);
path.Add(CustomerEntity.PrefetchPathOrderCollection);

myCustomerCollection.GetMulti(null,path);

The join is Orders.CustomerFK = Customers.CustomerPK. Very simple.

When I don't send in the path to GetMulti() I get correctly 1 order and everything works great in the app.

Ideas?

Couple of questions:

1. What's the value of myCustomerCollection[0].OrderCollection.Count before GelMulti?

2. What LLBLGen version are you using?

Hi David,

I called clear() on the collection before GetMulti().

My signature has the specs on the dev environment.

Cheers, Ian

Would you please examine the generated queries and run them directly against the database to see if they return the expected results?

I called clear() on the collection before GetMulti().

Would you please post complete re-pro code?

Make sure the order collection is not LazyLoaded before it was prefetched. Otherwise you may set the DoNotPerformAddIfPresent collection property to true.