BB84.EntityFrameworkCore.Repositories.SqlServer 4.4.625

BB84.EntityFrameworkCore.Repositories.SqlServer

This package provides SQL Server–specific entity type configuration base classes, SaveChangesInterceptor implementations for auditing and soft delete, and EntityTypeBuilderExtensions for temporal table support.

Installation

dotnet add package BB84.EntityFrameworkCore.Repositories.SqlServer

Configuration base classes

Inherit from these in your IEntityTypeConfiguration<TEntity> implementations and call base.Configure(builder) to apply the standard column order, constraints, concurrency tokens, and indexes. Override before or after the base call to add entity-specific configuration.

public class ProductConfiguration : IdentityConfiguration<Product>
{
    public override void Configure(EntityTypeBuilder<Product> builder)
    {
        base.Configure(builder);

        builder.ToTable("Products", "catalog");
        builder.Property(p => p.Name).IsRequired().HasMaxLength(200);
        builder.Property(p => p.Price).IsDecimalColumn(10, 2);
    }
}

public class InvoiceConfiguration : FullAuditedConfiguration<Invoice>
{
    public override void Configure(EntityTypeBuilder<Invoice> builder)
    {
        base.Configure(builder); // applies NEWID() default, sysname for audit columns

        builder.ToTable("Invoices", "billing");
        builder.Property(i => i.Number).IsRequired().HasMaxLength(50);
    }
}

public class ProductCategoryConfiguration : EnumeratorConfiguration<ProductCategory>
{
    public override void Configure(EntityTypeBuilder<ProductCategory> builder)
    {
        base.Configure(builder); // clustered int PK, Name unique index, IsDeleted default false
        builder.ToTable("ProductCategories", "catalog");
    }
}

Apply configurations via ApplyConfigurationsFromAssembly in OnModelCreating:

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.ApplyConfigurationsFromAssembly(typeof(AppDbContext).Assembly);
}

PropertyBuilderExtensions

Extension methods on PropertyBuilder that set the SQL Server column type in one call. All methods return the same PropertyBuilder for chaining.

Methods with a precision parameter throw ArgumentOutOfRangeException when the value is outside the valid range.

public class OrderConfiguration : IdentityConfiguration<Order>
{
    public override void Configure(EntityTypeBuilder<Order> builder)
    {
        base.Configure(builder);

        builder.ToTable("Orders", "sales");

        builder.Property(o => o.TotalAmount)
            .IsDecimalColumn(precision: 18, scale: 4);

        builder.Property(o => o.PlacedAt)
            .IsDateTimeOffsetColumn(precision: 3);

        builder.Property(o => o.DueDate)
            .IsDateColumn();

        builder.Property(o => o.Notes)
            .IsXmlColumn();

        builder.Property(o => o.Attachment)
            .IsVarbinaryColumn(); // varbinary(max)
    }
}

EntityTypeBuilderExtensions

ToHistoryTable

One-line setup for SQL Server temporal tables with a separate history schema:

builder.ToHistoryTable(
    tableName: "Orders",          // defaults to entity class name
    tableSchema: "sales",         // defaults to "dbo"
    historyTableName: "Orders",   // defaults to tableName
    historyTableSchema: "history" // defaults to "history"
);

Interceptors

Register interceptors on the DbContextOptionsBuilder:

services.AddSingleton<SoftDeletableInterceptor>();
services.AddSingleton<TimeAuditedInterceptor>();

services.AddDbContext<AppDbContext>((sp, options) =>
{
    options
        .UseSqlServer(connectionString)
        .AddInterceptors(
            sp.GetRequiredService<SoftDeletableInterceptor>(),
            sp.GetRequiredService<TimeAuditedInterceptor>());
});

SoftDeletableInterceptor

Fires on SavingChanges/SavingChangesAsync. For every entity tracked as Deleted that implements ISoftDeletable, it sets IsDeleted = true and changes the state to Modified — preventing a physical DELETE from being issued.

TimeAuditedInterceptor

Fires on SavingChanges/SavingChangesAsync. For every entity implementing ITimeAudited:

• EntityState.Added → sets CreatedAt = DateTimeOffset.UtcNow
• EntityState.Modified → sets EditedAt = DateTimeOffset.UtcNow

CreatedBy / EditedBy are not set automatically by this interceptor — implement a custom SaveChangesInterceptor for user auditing and register it alongside the built-in ones.