where 子查询中表名错误，返回

SqlSugar

 6  139

悬赏：5 飞吻

测试用例

private static void Subquery()

{

Console.WriteLine("");

Console.WriteLine("#### Subquery Start ####");

var db = GetInstance();

var list = db.Queryable<Orders>().Take(10).Select(it => new

{

customName=SqlFunc.Subqueryable<Custom>().Where("it.CustomId=id").Select(s=>s.Name),

customName2 = SqlFunc.Subqueryable<Custom>().Where("it.CustomId = id").Where(s => true).Select(s => s.Name)

}).ToList();

var list2 = db.Queryable<Orders>().Where(it => SqlFunc.Subqueryable<OrderItem>().Where(i => i.OrderId == it.Id).Any()).ToList();

Console.WriteLine("#### Subquery End ####");

}

最后生成的SQL：

SELECT Id,Name,Price,CreateTime,CustomId FROM Orders it WHERE (EXISTS ( SELECT * FROM OrderItem i WHERE ( OrderId = it.Id ) ))

OrderItem 是类名，真实表名应该是 OrderDetail ，这段SQL 是在哪里生成的，怎么调试。

热忱回答（6）