在LeftJoin的Select中添加自定义计算列无法正常返回 返回
SqlSugar
处理完成
1
426
悬赏:0 飞吻
DbContext.Queryable<Table1>() .LeftJoin(DbContext.Queryable<Table2>(), (t1, t2) => t1.LinkId = t2.Id) .Select((t1, t2) => new { t1.LinkId t1.Name,
t2Exists = t2 != null,
t2.Id, t2.Name }) .ToList();查询后会产生如下错误
Could not convert string to boolean: NULL. Path 't2Exists', line XX, position XX.
运行时: .NET 8.0
SqlSugar版本: 5.1.4.173
热忱回答(1)
-
fate sta VIP0
2025/1/13t2Exists = t2.主键!=null,
或者 int主键 t2Exists = t2.主键>0,
0 回复