23083627850

Committed 14 Mar 2026 07:47AM UTC coverage: 60.096%. First build

Build # 23083627850

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

35 of 149 new or added lines in 8 files covered. (23.49%)

2009 of 3343 relevant lines covered (60.1%)

664.11 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

33.33

/src/LLL.AutoCompute.EFCore/Metadata/Internal/DesignTimeComputedStore.cs

using Microsoft.EntityFrameworkCore.Metadata;

namespace LLL.AutoCompute.EFCore.Metadata.Internal;

public static class DesignTimeComputedStore
{
    /// <summary>
    /// Factories collected during model finalization (before temp annotations are removed).
    /// Available for use after the model is finalized.
    /// </summary>
    public static IReadOnlyList<(IProperty Property, ComputedMemberFactory<IProperty> Factory)>? Factories { get; set; }

    /// <summary>
    /// Computed members created from the factories after model finalization.
    /// </summary>
    public static IReadOnlyList<ComputedMember>? ComputedMembers { get; set; }

    public static IComputedExpressionAnalyzer? ExpressionAnalyzer { get; set; }
}

1	using Microsoft.EntityFrameworkCore.Metadata;
2
3	namespace LLL.AutoCompute.EFCore.Metadata.Internal;
4
5	public static class DesignTimeComputedStore
6	{
7	/// <summary>
8	/// Factories collected during model finalization (before temp annotations are removed).
9	/// Available for use after the model is finalized.
10	/// </summary>
11	public static IReadOnlyList<(IProperty Property, ComputedMemberFactory<IProperty> Factory)>? Factories { get; set; }	192✔
12
13	/// <summary>
14	/// Computed members created from the factories after model finalization.
15	/// </summary>
NEW 16	public static IReadOnlyList<ComputedMember>? ComputedMembers { get; set; }	×
17
NEW 18	public static IComputedExpressionAnalyzer? ExpressionAnalyzer { get; set; }	×
19	}

lucaslorentz / auto-compute / 23083627850

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous