LLBLGen nested select

How can I make a nested select statment with LLBLGen?

I have the fo开发者_JAVA百科llowing sql statement.

Select * from Users where User.UserId in (select ManagerId from LnkUserManagers)

Thanks in advance.

Use a FieldCompareSetPredicate:

http://www.llblgen.com/documentation/2.6/hh_goto.htm#Using%20the%20generated%20code/Adapter/Filtering%20and%20Sorting/gencode_filteringpredicateclasses_adapter.htm#FieldCompareSetPredicate