資料庫操作預計會影響1行，但實際影響92085行資料可能已被修改或洗掉

我的 GraphQL .NET 服務器上有這段代碼。
它應該做一個簡單的更新查詢。
請注意，洗掉、創建和讀取都可以。
上面評論的所有更新可能性都給了我這個錯誤：

Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException: The database operation was expected to affect 1 row(s), but actually affected 92085 row(s); data may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=527962 for information on understanding and handling optimistic concurrency exceptions.
   at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ThrowAggregateUpdateConcurrencyException(Int32 commandIndex, Int32 expectedRowsAffected, Int32 rowsAffected)
   at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.ConsumeResultSetWithoutPropagation(Int32 commandIndex, RelationalDataReader reader)
   at Microsoft.EntityFrameworkCore.Update.AffectedCountModificationCommandBatch.Consume(RelationalDataReader reader)
   at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.Execute(IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.Execute(IEnumerable`1 commandBatches, IRelationalConnection connection)
   at Microsoft.EntityFrameworkCore.Storage.RelationalDatabase.SaveChanges(IList`1 entries)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(IList`1 entriesToSave)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(StateManager stateManager, Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.<>c.<SaveChanges>b__104_0(DbContext _, ValueTuple`2 t)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges(Boolean acceptAllChangesOnSuccess)
   at Microsoft.EntityFrameworkCore.DbContext.SaveChanges()
   at GlanumAppsApi.Controllers.TimeTrackingController.CreateTimeTracking(TimeTrackingModel timeTracking) in C:\Users\Edouard\RiderProjects\GlanumAppsApi\GlanumAppsApi\Controllers\TimeTrackingController.cs:line 62

我嘗試了很多東西。
我嘗試了并發令牌、時間戳以及Google 上可能存在的所有內容。

    public TimeTrackingModel CreateTimeTracking(TimeTrackingModel timeTracking)
    {
        try
        {
            var ctx = _context();
            if (timeTracking.Id > 0)
            {
                
                /*
                var entry = ctx.TimeTrackings.Find(timeTracking.Id)!;
                ctx.Entry(entry).CurrentValues.SetValues(timeTracking);
                //ctx.TimeTrackings.Update(entry);
                var test = ctx.ChangeTracker.ToDebugString();
                ctx.SaveChanges();
                */
                

                
                var entry = ctx.TimeTrackings.Find(timeTracking.Id)!;
                entry.Commentaire = "ziofjzie";
                // ctx.Entry(entry).CurrentValues.SetValues(timeTracking);
                // ctx.TimeTrackings.Update(entry);
                // ctx.Entry(entry).State = EntityState.Modified;
                var test = ctx.ChangeTracker.ToDebugString();
                ctx.SaveChanges();
                

                /*
                ctx.TimeTrackings.Attach(timeTracking);
                ctx.TimeTrackings.Update(timeTracking);
                var test = ctx.ChangeTracker.ToDebugString();
                ctx.SaveChanges();
                */
                
            }
            else
            {
                ctx.TimeTrackings.Add(timeTracking);
                ctx.SaveChanges();
            }

            return timeTracking;
        }
        catch
        {
            return new TimeTrackingModel();
        }
    }

測驗變數，在我的一個錯誤測驗中，給了我這個結果：

TimeTrackingModel {Id: 92085} Modified
  Id: 92085 PK
  Chevauchement: <null> Modified
  Commentaire: 'ziofjzie' Modified Originally 'test'
  DateCreation: <null> Modified
  DateModification: <null> Modified
  DateSuppression: <null> Modified
  Debut: '22/04/1978 06:00:00' Modified
  EstDeductible: 'True' Modified
  Fin: '22/04/1981 06:00:00' Modified
  Id_Tache: 1 FK Modified
  Id_Utilisateur: 5 FK Modified
  Tache: <null>
  Utilisateur: <null>

如您所見，物體框架核心 6 為我提供了預期的正確更改，但仍然拋出該錯誤。
這是資料庫條目：

Id  Debut   Fin DateCreation    DateModification    DateSuppression Id_Utilisateur  Id_Tache    Chevauchement   Commentaire estDeductible
92086   1979-04-22 06:00:00.000 1982-04-22 06:00:00.000 NULL    NULL    NULL    5   1   _92085_ sdfsdfsdf   1
92085   1978-04-22 06:00:00.000 1981-04-22 06:00:00.000 NULL    NULL    NULL    5   1   _92086_ test    1

uj5u.com熱心網友回復：

由@David Browne 解決 - Microsoft 我關閉了觸發器

DISABLE TRIGGER TimeTracking_OnInsertUpdateDelete on TimeTracking;
DISABLE TRIGGER TimeTracking_AspNet_SqlCacheNotification_Trigger on TimeTracking;

它現在正在作業！:)

標籤：C＃ sql服务器 实体框架 asp.net 核心 实体框架核心

上一篇：如何首先在代碼中保存外鍵的集合

下一篇：物體框架可以像下劃線一樣處理嗎？