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

是否支持限制更新数目 #1132

Closed jinzaz closed 1 year ago

jinzaz commented 1 year ago

例如更新符合条件的固定3条记录,是否支持

DotNetNext commented 1 year ago
 var list=db.Queryable<Order>().Take(3).ToList();
        db.Updateable(list).ExecuteCommand();
DotNetNext commented 1 year ago

目前可以查询在删除

jinzaz commented 1 year ago

好的,这种方式对我可能不合适,这种会导致并发时重复查询到前三条再修改,谢谢回复