Is it possible to use a FieldCompareSetPredicate where the set of values is defined by a view.

Example query:

SELECT *
FROM Customers
WHERE customerId IN (SELECT CustomerId FROM v_Orders WHERE order_id = @id)

Another solution would be if I could add a relation between an Entity and a TypedView. Then the query would be something like this:

SELECT Customers.*
FROM Customers
INNER JOIN v_Orders ON Customers.CustomerId = v_Orders.CustomerId
WHERE v_Orders.order_id = @id

You could also Map a view as an entity and create the relation at desinger, then you could use the FieldCompareSetPredicate.

Hmm, a clear case of RTM. Thank you for your reply.

Give a try. If you encounter problems, please let us know.