.agents/skills/update-pipeline/SKILL.md
Converts tracked entity changes into database INSERT/UPDATE/DELETE commands during SaveChanges().
SaveChanges() → DetectChanges() → IDatabase.SaveChanges()
→ UpdateAdapter creates IUpdateEntry list
→ CommandBatchPreparer.BatchCommands()
→ ModificationCommand per entity (maps to table row), composed of ColumnModification (maps to column value)
→ Topological sort via Multigraph (FK dependency ordering)
→ Groups into ModificationCommandBatch (respects max batch size)
→ UpdateSqlGenerator generates SQL per batch
→ BatchExecutor executes all batches in a transaction
→ StateManager.AcceptAllChanges()
Other Key Files:
src/EFCore.Relational/Update/Internal/SharedTableEntryMap.cs — manages entries mapped to the same rowConcurrency tokens → WHERE conditions on UPDATE/DELETE. AffectedCountModificationCommandBatch checks affected rows. Throws DbUpdateConcurrencyException on mismatch.
SaveChanges() returns expected affected row countDbUpdateConcurrencyException thrown when expected for stale data