Hi

I need realize SQL command (NorthWind database):

SELECT * FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order Details].ProductID INNER JOIN Orders ON [Order Details].OrderID = Orders.OrderID WHERE (Orders.OrderID = @param)

I can do it using PrefetchPath, but our app need use RelationPredicateBucket. Can you help me. I'm LLBLGenPro beginner.

Thanks

OrderEntity o = new OrderEntity(10254); IRelationPredicateBucket filter = o.GetRelationInfoProducts(); // add additional filter to filter.PredicateExpression for example. adapter.FetchEntityCollection(o.Products, filter);

Is this what you're looking for?