子查询不支持Contains吗? 返回
SqlSugar
待处理
169
三木水公 发布于2周前
悬赏：5 飞吻
int TotalCount = 0; var List = Context.Queryable<ClientTransportQuote>()
.Select(Q => new
{
ClientNames = SqlFunc.Subqueryable<Client>()
.Where(C => Q.ClientIds.Contains(C.ClientId))
.ToList(C => C.Name)
})
.ToPageList(Dto.PageIndex, Dto.PageSize, ref TotalCount);生成的Sql是
2026-07-17 11:59:53.7243 | INFO | [Basics] SELECT Count(*) FROM `ClientTransportQuote` `Q`
2026-07-17 11:59:53.7929 | INFO | [Basics] SELECT * FROM `ClientTransportQuote` `Q` LIMIT 0,20
2026-07-17 11:59:53.8636 | INFO | [Basics] (SELECT `C`.`Name`,0 as sugarIndex FROM `Client` `C` WHERE (1=2) )