lucaslorentz / auto-compute

60%

main: 60%

LAST BUILD ON BRANCH feature/migration-backfill

branch: feature/migration-backfill

CHANGE BRANCH

x

Reset

• feature/migration-backfill
• add-dependabot
• dependabot/github_actions/github-actions-308ca1fd7f
• feature/dotnet10-support
• fix-manifest
• fix/msb4011-and-caching-vuln
• fix/suppress-ad0001
• improve-auto-compute
• improve-inheritance-support
• main
• refs/tags/v1.0.0
• refs/tags/v1.1.0
• refs/tags/v1.2.0
• refs/tags/v1.3.0
• refs/tags/v1.4.0
• refs/tags/v1.5.0
• refs/tags/v1.6.0

Build # 23084474323

Build Type

Pull #19

github

Committed by lucaslorentz

Commit Message

Add automatic backfill SQL generation in migrations for computed properties

When a computed property is added or its expression changes, `dotnet ef migrations add`
now automatically generates `migrationBuilder.Sql("UPDATE ...")` to update existing records.

- SHA256 hash of expanded expression stored as permanent annotation for change detection
- Uses ExecuteUpdate + SqlCaptureInterceptor for provider-agnostic SQL generation
- Configurable via `EnableBackfillInMigrations` (enabled by default)
- Untranslatable expressions generate a friendly SQL comment
- Existing properties without hashes are skipped (assumes consistency)
- Removes code coverage threshold from CI

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

Pull Request Pull Request #19: Automatic backfill SQL generation in migrations

Coverage Stats

21 of 148 new or added lines in 8 files covered. (14.19%)

1995 of 3342 relevant lines covered (59.69%)

663.56 hits per line