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

to many parameters #1262

Closed ricoisme closed 3 months ago

ricoisme commented 3 months ago

請教一下 使用下面程式碼進行無主鍵刪除，當dictionary數量太多會發生 to many parameters 的錯誤， 是否有其他寫法呢?還是如何避免? 謝謝

var dcs = _sqlSugarClient.Utilities.DataTableToDictionaryList(dt); var total = await _sqlSugarClient.Deleteable().AS(fullTableName) .WhereColumns(dcs).ExecuteCommandAsync(); return total;

DotNetNext commented 3 months ago

await db.Utilities.PageEachAsync(allList, 100 ,async pageList=> { await xxxxxxx.WhereColumns(pageList)ExecuteCommandAsync(); });

DotNetNext commented 3 months ago

非实体操作可以这样分页， 实体操作支持就直接能用.Deleteable.PageSize

ricoisme commented 3 months ago

感謝

  • © Githubissues.
  • Githubissues is a development platform for aggregating issues.