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

导航 到的表是分表 ，能不能在查询的时候 让我自定义分表 #1227

Closed leida1983 closed 3 months ago

leida1983 commented 3 months ago

var list = db.Queryable() .Includes(x => x.Books) .ToList();

比如用上面的例子 Books 如果是 SplitTable 的时候，我希望后面可以定义 分表的范围 .SplitTable(tabs => tabs.Take(3)) 这样子 来缩小查询范围

DotNetNext commented 3 months ago

SqlSugarCore 5.1.4.146-preview03 更新到这个版本

using SqlSugar.SplitTableExtensions

var list = db.Queryable() .Includes(x => x.Books.SplitTable(x=>x.Take(1)).ToList() ) .ToList();