I want to fetch entities using a condition which is matched in a child collection, for example, an Order has a OrderDetails collection, OrderDetails has a field ItemNo, I want to get a collection of Order entitis which contains OrderDetail with a specified ItemNo.

SQL statement would be like this: Select Order.* from Order inner join OrderDetail on Order.OrderNo = OrderDetail.OrderNo where OrderDetail.ItemNo = 'xxx'

How can I do it using adapter? Thanks!

Barry wrote:

I want to fetch entities using a condition which is matched in a child collection, for example, an Order has a OrderDetails collection, OrderDetails has a field ItemNo, I want to get a collection of Order entitis which contains OrderDetail with a specified ItemNo.

SQL statement would be like this: Select Order.* from Order inner join OrderDetail on Order.OrderNo = OrderDetail.OrderNo where OrderDetail.ItemNo = 'xxx'

How can I do it using adapter? Thanks!

Barry,

Take a look at this page in the LLBLGen User Manual.

**_Generated code - Filtering and sorting, Adapter _**

Multi-entity filters section explains how to build this retrieval query.

Select Order.* from Order inner join OrderDetail on Order.OrderNo = OrderDetail.OrderNo
where OrderDetail.ItemNo = 'xxx'

Custom filters for EntityRelations section explains how to build this retrieval query; which should be slightly more efficient.

Select Order.* from Order inner join OrderDetail on Order.OrderNo = OrderDetail.OrderNo and OrderDetail.ItemNo = 'xxx'