分表问题更新数量+1问题 返回
eric 发布于1周前
var u = Context.Updateable(main) .IgnoreNullColumns() .IgnoreColumns(it => new { it.Create_Time, it.Create_User }) .PublicSetColumns(it => it.Packed_Qty, it => SqlFunc.IsNull(it.Packed_Qty, 0) + 1) .WhereColumns(it => new { it.Id }) .SplitTable(tabs => tabs.Take(6)) 分表情况下,更新累计+1时,使用上面的语句会导致累计重复,实际有几张表,就会重复更新几次;如下,是有2个实体表时,sql被执行了2次;这个是bug还是我的写法有问题?
UPDATE [Packing_Main_20260901] SET [Plan_Qty]=2,[Packed_Qty]=(ISNULL([Packed_Qty],0) + 1 ) WHERE [Id]=353558359535783936
UPDATE [Packing_Main_20260901] SET [Plan_Qty]=2,[Packed_Qty]=(ISNULL([Packed_Qty],0) + 1 ) WHERE [Id]=353558359535783936
热忱回答(1)
-
fate sta VIP0
1周前那就是不支持分表
0 回复