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

能否给分表也加个软删除的方法 #1225

Closed supersdar closed 4 months ago

supersdar commented 4 months ago
db.Deleteable<T>().In(ids).SplitTable().IsLogic().ExecuteCommandAsync("IsDeleted");
DotNetNext commented 4 months ago

近期支持

DotNetNext commented 4 months ago

//范围更新
var tables = db.SplitHelper<OrderSpliteTest>().GetTables().Take(3);//近3张分表
foreach (var item in tables)
{
     db.Deleteable<SpitDemoModel>()
         .AS(item.TableName)//设置分表名
         .In(1)//主键值
         .IsLogic() 
        .ExecuteCommand();
}

目前假删只能用这种方式实现

DotNetNext commented 4 months ago

分表中 所有SQL方式的更新 或者删除 都只能通过 上面的写法实现