Transformations.EntityFramework 2.0.4.1

Transformations.EntityFramework

Resilient SaveChanges, structured audit extraction, and IQueryable CSV export for EF Core — without subclassing DbContext or adding custom interceptors.

📖 Overview

Transformations.EntityFramework equips any standard DbContext with resilient saves, structured audit extraction, and IQueryable CSV export — without subclassing DbContext or writing custom interceptors.

🚀 Why Transformations.EntityFramework?

EF Core is powerful, but two things require disproportionate effort: handling transient connectivity drops (Azure SQL throttling, network blips) and capturing exactly which properties changed before a save. The standard workarounds — custom execution strategies, SaveChanges overrides, manual ChangeTracker loops — mean boilerplate in every project. These extensions inject both capabilities as simple extension method calls on any existing DbContext.

📦 Install

<PackageReference Include="Transformations.EntityFramework" Version="2.0.4.1" />

💡 What's Included

Resilient SaveChanges

Wraps SaveChangesAsync with exponential backoff and optional exception filters. Handles transient connectivity drops on Azure SQL and other cloud databases.

// 4 retries, 250ms initial delay (doubles each attempt)
int rowsAffected = await context.SaveChangesWithRetryAsync(
    retryCount: 4,
    initialDelay: TimeSpan.FromMilliseconds(250));

// With cancellation token
await context.SaveChangesWithRetryAsync(cancellationToken: ct);

ChangeTracker Audit Extraction

Captures structured AuditEntry records from EF Core's ChangeTracker before calling SaveChanges. After save, entity states are reset — so capture first.

// Capture all pending Added/Modified/Deleted changes
var audit = context.GetAuditEntries();

// Or filter to a specific state
var modified = context.GetAuditEntries(EntityState.Modified);

await context.SaveChangesWithRetryAsync();

foreach (var entry in modified)
{
    logger.LogInformation("{Entity} [{Key}] — {Prop}: {Old} → {New}",
        entry.EntityType,
        entry.KeyValues,
        entry.PropertyName,
        entry.OriginalValue,
        entry.CurrentValue);
}

AuditEntry properties: EntityType, State, PropertyName, OriginalValue, CurrentValue, KeyValues, TimestampUtc.

IQueryable → CSV Export

Materializes a query and joins results with a configurable separator. Each element is rendered via ToString().

// Comma-separated (default)
string csv = await context.Users
    .Where(u => u.IsActive)
    .Select(u => u.Email)
    .ToCsvAsync();

// Custom separator
string tsv = await context.Users
    .Select(u => u.Name)
    .ToCsvAsync(separator: '\t');

🛠 API Reference

📦 Dependencies

• Transformations.Core
• Microsoft.EntityFrameworkCore

License

MIT — Copyright © 2026 opentail.net