LLBLGen嵌套select

Question

如何使用LLBLGen创建嵌套的select语句？

我有以下sql语句。

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

提前谢谢。

Answer 1

使用FieldCompareSetPredicate：

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