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.24k stars 1.33k forks source link

新增支持跨库子查询方法 #1164

Closed pinzi closed 11 months ago

pinzi commented 1 year ago

1.新增SqlFunc.SubqueryableWithAttr方法支持跨库子查询 2.新增SqlFunc.Subqueryable(bool IsCrossQueryWithAttr = false)方法支持跨库子查询

pinzi commented 1 year ago

只测试了SQLSERVER数据库

DotNetNext commented 11 months ago 
        db.Queryable<Order>()
            .Select(it => new { 
             x= SqlFunc.Subqueryable<OrderItem>().AsWithAttr().Select(s => s.OrderId)
            })
            .ToList();
DotNetNext commented 11 months ago

最新预览版本已支持AsWithAttr ，规则 和 QueryableWithAttr一样