search

DotNetNext / SqlSugar

.Net aot ORM Fastest ORM Simple Easy VB.NET Sqlite orm Oracle ORM Mysql Orm 虚谷数据库 postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm Object/Relational Mapping
https://www.donet5.com/Home/Doc
MIT License
5.17k stars 1.32k forks source link

SqlFunc.Subqueryable 跨库子查询联表无效 #1246

Closed dasiniwoyebushuo closed 1 month ago

dasiniwoyebushuo commented 1 month ago

跨库单表有效： SqlFunc.Subqueryable<FlowBoxInfo>().AsWithAttr() .Where(f => a.IncomingId.Equals(f.IncomingId)) .Sum(f => f.Qty), 跨库多表无效： SqlFunc.Subqueryable<FlowBoxInfo>().AsWithAttr() .LeftJoin<BoxInfo>((f, g) => f.BoxInfoId.Equals(g.Id) && g.StorageInfoId.HasValue) .LeftJoin<StorageInfo>((f, g, h) => h.Id.Equals(g.StorageInfoId)) .Where(f => a.IncomingId.Equals(f.IncomingId)) .Sum(f => f.Qty),

DotNetNext commented 1 month ago

支持中 ，先可以用.LeftJoin((f, g, h) => h.Id.Equals(g.StorageInfoId) ,"表名")

DotNetNext commented 1 month ago

SqlSugarCore 5.1.4.157-preview06

更新最新预览版本已支持