Explain EF Core's SaveChanges update pipeline converting tracked changes into SQL commands.
npx skills add https://github.com/dotnet/efcore --skill update-pipeline
Please help me install this Agent Skill. Skill: update-pipeline Source: https://github.com/dotnet/efcore/tree/main/.agents/skills/update-pipeline Command: npx skills add https://github.com/dotnet/efcore --skill update-pipeline
This Skill provides implementation details for the EF Core SaveChanges update pipeline, describing how tracked changes are converted into database commands and the key components involved (UpdateAdapter, ModificationCommand, Batch processing, UpdateSqlGenerator, etc.)
Review the update pipeline flow and its components to understand how EF Core translates changes into SQL.
High-intent search queries and answers about installing and using this skill.
EF Core SaveChanges translates tracked changes into SQL commands by passing modifications through the Update Pipeline, which utilizes CommandBatchPreparer, UpdateSqlGenerator, and ModificationCommand components to generate and execute store-specific operations.
EF Core handles foreign key dependencies during SaveChanges by applying topological sorting via a Multigraph, ensuring that ModificationCommands are ordered correctly to respect relational constraints before batch execution.
Store-generated values are validated during the EF Core update pipeline through specific propagation logic within the UpdateAdapter, ensuring database-generated keys and defaults are correctly mapped back to tracked entities.
When a concurrency check fails during EF Core SaveChanges, the update pipeline throws a DbUpdateConcurrencyException, halting the transactional BatchExecutor to signal a data mismatch between the tracked entity and the database row.
EF Core groups ModificationCommands into batches by respecting the configured maximum batch size, executing these grouped commands transactionally using a BatchExecutor to optimize database roundtrips during SaveChanges.
bmslabsCreate Entity Framework Core entities with properties, validations, and DbContext wiring.
jonico22Define Prisma schemas in .prisma files and generate a type-safe database client with migrations and CRUD support.
isharoverwhiteImplement SQLAlchemy 2.0 ORM models for Python database operations.
BlackBeltTechnologyImplement custom authentication and authorization providers in the JUDO runtime framework.
