Stratara.EventSourcing.EntityFrameworkCore 4.0.4

Prefix Reserved
There is a newer version of this package available.
See the version list below for details.
dotnet add package Stratara.EventSourcing.EntityFrameworkCore --version 4.0.4
                    
NuGet\Install-Package Stratara.EventSourcing.EntityFrameworkCore -Version 4.0.4
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Stratara.EventSourcing.EntityFrameworkCore" Version="4.0.4" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Stratara.EventSourcing.EntityFrameworkCore" Version="4.0.4" />
                    
Directory.Packages.props
<PackageReference Include="Stratara.EventSourcing.EntityFrameworkCore" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Stratara.EventSourcing.EntityFrameworkCore --version 4.0.4
                    
#r "nuget: Stratara.EventSourcing.EntityFrameworkCore, 4.0.4"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package Stratara.EventSourcing.EntityFrameworkCore@4.0.4
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Stratara.EventSourcing.EntityFrameworkCore&version=4.0.4
                    
Install as a Cake Addin
#tool nuget:?package=Stratara.EventSourcing.EntityFrameworkCore&version=4.0.4
                    
Install as a Cake Tool

Stratara.EventSourcing.EntityFrameworkCore

Derived. The behaviour described here is specified under openspec/specs/. Those specifications are the source; this page explains and illustrates them.

License: MIT.

EF Core persistence for the Stratara event-sourced stack — PostgreSQL flavoured via Npgsql + pgvector. Bundles four previously-separate Stratara projects into one NuGet because they always ship together:

Folder Contents Old csproj
EntityFrameworkCore/ shared EF conventions, value generators, IDbContext / IReadDbContext / IWriteDbContext / ITenantScopedDbContext / IIdentityDbContext, UnitOfWork base, DefaultDbResolver, NpgsqlDbContextServiceCollectionExtensions, DbContextMigrationUtility Stratara.EntityFrameworkCore
WriteStore/ WriteDbContext, WriteUnitOfWork, event-stream/snapshot/event-chain/command-audit/outbox repositories + entity configurations Stratara.EventSourcing.EntityFrameworkCore.WriteStore
ReadStore/ ReadDbContext, ReadUnitOfWork, ProjectionsUnitOfWork, Tenant repository, projection entity configurations Stratara.EventSourcing.EntityFrameworkCore.ReadStore
IdentityStore/ Generic ASP.NET Identity IdentityDbContext + marker Stratara.EventSourcing.EntityFrameworkCore.IdentityStore

Everything lives under Stratara.EventSourcing.EntityFrameworkCore and its sub-namespaces (.WriteStore, .ReadStore, .IdentityStore, .Abstractions, .Conventions, .Extensions, .HealthChecks, .Migration). The DI extensions sit in Microsoft.Extensions.DependencyInjection, per the Microsoft convention, so they resolve without an extra using.

Why folded

WriteStore-without-ReadStore is not a real use case. EF conventions + value generators + UnitOfWork primitives are foundational for every other store. ASP.NET Identity glue follows the same EF Core conventions. Splitting into 4 NuGets that always ship together adds version-management noise (4× <PackageVersion> to keep in sync, transitive-resolution risk) without any consumer benefit.

If your application doesn't use ASP.NET Identity, simply don't reference IdentityDbContext-derived types — the rest of the package works without them.

Quick start

Derive your contexts from the generic base classes — the type argument is the context itself:

using Stratara.EventSourcing.EntityFrameworkCore.WriteStore;
using Stratara.EventSourcing.EntityFrameworkCore.ReadStore;

public sealed class MyAppWriteDbContext(DbContextOptions<MyAppWriteDbContext> options)
    : WriteDbContext<MyAppWriteDbContext>(options);

public sealed class MyAppReadDbContext(DbContextOptions<MyAppReadDbContext> options)
    : ReadDbContext<MyAppReadDbContext>(options);

Then register the Npgsql context factories and the write store. Each factory registration also registers the unit of work over its context — IWriteUnitOfWork for the write side, IProjectionsUnitOfWork / IReadUnitOfWork for the read side — unless the host registered its own. The write-side unit of work also draws on ISessionContextProvider and ISecureJsonSerializer, which AddSessionContext() and AddSecurity() provide (every worker composite applies both); with those in place, this is all the store needs from the host:

// In your AppHost / Worker / Web project:
builder.Services
    .AddNpgsqlWriteDbContextFactory<MyAppWriteDbContext>()
    .AddNpgsqlReadDbContextFactory<MyAppReadDbContext>()
    .AddWriteStore(builder.Configuration);                    // binds Stratara:EventSourcing options

Most hosts don't call these directly — the worker composites in Stratara.EventSourcing.WorkerDefaults (AddCommandWorkerServices(), AddEventProjectionWorkerServices(), …) already compose AddWriteStore for you. Reach for the explicit form when you build a host that none of the composites fit.

Renamed in 3.2.0, removed in 4.0.0: the write-side factory was AddNpsqlWriteDbContextFactory (missing the g) through 3.1.x. AddNpgsqlWriteDbContextFactory replaced it in 3.2.0 and the old spelling stayed as an [Obsolete] alias until 4.0.0, which removed it. A host still on the old spelling adds the g; nothing else about the call changes.

Health checks

Two opt-in readiness checks plug into any IHealthChecksBuilder (they require the write store above to be registered):

builder.Services.AddHealthChecks()
    .AddEventStoreHealthCheck()                                  // write-side DB reachable?
    .AddOutboxHealthCheck(degradedThreshold: 1_000,             // outbox backlog depth
                          unhealthyThreshold: 10_000);
  • AddEventStoreHealthCheck() — probes write-store connectivity; Unhealthy when the database cannot be reached.
  • AddOutboxHealthCheck(degradedThreshold?, unhealthyThreshold?) — reports the pending outbox backlog under the pending data key and escalates to Degraded / Unhealthy when the count crosses the supplied thresholds (omit them to stay healthy while reachable).

Both are tagged ready by default, so they show up on a readiness endpoint rather than the liveness (live) one.

Dependencies

  • Stratara.Projections — for projection types used by ProjectionsUnitOfWork.
  • Stratara.Shared — for diagnostics + abstractions + resilience.
  • Npgsql.EntityFrameworkCore.PostgreSQL, EFCore.NamingConventions, Microsoft.AspNetCore.Identity.EntityFrameworkCore, Microsoft.EntityFrameworkCore, Microsoft.Extensions.Diagnostics.HealthChecks, Pgvector.EntityFrameworkCore.
Product Compatible and additional computed target framework versions.
.NET net10.0 is compatible.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (4)

Showing the top 4 NuGet packages that depend on Stratara.EventSourcing.EntityFrameworkCore:

Package Downloads
Stratara.Infrastructure

Infrastructure glue for the Stratara framework — authorization decorators, configuration providers, and DI composition helpers that wire Mediator, Outbox, Identity, and EF Core into a hosted app.

Stratara.EventSourcing.WorkerDefaults

Worker-host wiring composites for the Stratara event-sourced stack. IHostApplicationBuilder extensions (AddBackendServices, AddCommandWorkerServices, AddHeavyCommandWorkerServices, AddEventProjectionWorkerServices, AddEventStreamHashWorkerServices, AddSagaWorkerServices, AddOutboxWorkerServices, and AddCommandServices, AddEventProjectionServices and AddSagaServices without the bus-fed workers) bundle the per-concern DI calls so each worker host opts in with one line.

Stratara.Testing.EntityFrameworkCore

Spin up the real Stratara event-sourcing write stack (EventSource, aggregation, snapshots, the EF Core write store) against a shared in-memory SQLite database in one call — production code paths, no Postgres, no Docker. Builds on Stratara.Testing's in-memory doubles.

Stratara.Orleans.EntityFrameworkCore

Entity Framework Core persistence for the Stratara Orleans execution model — the commit-order readers (native PostgreSQL and a portable per-partition counter), the projection checkpoint store and the store-schema additions they need.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
4.2.0 36 9/18/2026
4.1.1 74 9/16/2026
4.1.0 77 9/16/2026
4.0.4 614 9/14/2026
4.0.3 190 9/3/2026
4.0.2 612 9/3/2026
4.0.1 221 9/2/2026
4.0.0 178 8/31/2026
4.0.0-preview.1 76 8/31/2026
3.4.0 158 8/28/2026
3.3.0 133 8/25/2026
3.2.3 144 8/22/2026
3.2.2 138 8/14/2026
3.2.1 140 8/2/2026
3.2.0 157 7/18/2026
3.1.7 406 7/1/2026
3.1.6 572 6/22/2026
3.1.5 159 6/22/2026
3.1.4 168 6/15/2026
3.1.3 155 6/10/2026
Loading failed

Three findings from a proof of concept of an alternative execution model, each fixed on the shipped
path. A message a handler cannot take is now redelivered a bounded number of times and then
dead-lettered on both brokers instead of being dropped on one of them; an opt-in closes the window
in which a committed fact could be lost between the commit and its publication; and a version
collision is a concurrency conflict on every supported database provider, not only on PostgreSQL.
Additive on every published surface, with one operator step on RabbitMQ: the worker queues change
name and type, and the old ones are deleted once drained.

### Added

- `Outbox:DurableBundles` (`OutboxOptions.DurableBundles`, default `false`): an event bundle is
 written to the outbox table in the transaction that commits its events, published after the
 commit, and removed once the bus has accepted it — so a process that ends between the commit and
 the publish no longer loses the bundle for every subscription. `IEventBundleOutboxDispatcher`
 gains `StoresBundlesWithCommit` and `StoreEventBundleAsync`, and `IOutboxRepository` an
 `AddAsync(Guid id, …)` overload, all default-implemented so a consumer's own implementations keep
 compiling and keep bus-first. `AddOutboxDispatcher()` now binds the `Outbox` section when the host
 carries a configuration. Log event `106_108` records a stored copy the bus accepted but the
 framework could not remove. The default path is unchanged; the specification now names its window.

- `IStoreConflictDetector` in `Stratara.Abstractions.EventSourcing`: recognises a database
 provider's refusal of a duplicate stream version, so the event source can surface it as a
 `ConcurrencyException` on that provider. `AddNpgsqlWriteDbContextFactory<T>()` registers the
 PostgreSQL detector and `AddStrataraTestingEventStore<T>()` the SQLite one; detectors accumulate,
 so a host on another provider adds its own without displacing the framework's. A host that
 registers its write context without `AddNpgsqlWriteDbContextFactory<T>()` gets no detector and
 no longer sees a `ConcurrencyException` on a version collision: it switches to that registration,
 or registers an `IStoreConflictDetector` of its own that recognises PostgreSQL's SQL state
 `23505` in the exception chain (the framework's implementations are not public).

- `MessageRetryOptions` (`Stratara.Abstractions.Messaging`, section `MessageRetry`):
 `MaxDeliveryAttempts` (default 3) and `MaxConflictRequeues` (default 100), bound and validated by
 `AddMessaging()` and by both `AddAzureServiceBus*` registrations. `MessageRetryPolicy` is the
 decision both transports apply. Log event `108_110` and counter `messaging.dead_lettered`
 (tags `messaging.topic`, `messaging.subscription`, `reason`) record every dead-lettering; `108_111`
 warns when a Service Bus subscription's `MaxDeliveryCount` is below the bounds.

### Changed

- A save now maps and signs its event bundle before the transaction opens, so a save with no
 session context — or a signer that fails — fails before anything is committed rather than after
 the commit with the events stranded unpublished.
- **RabbitMQ worker subscriptions are quorum queues with a dead-letter queue, under a new name.**
 A message whose handler throws is redelivered up to `MaxDeliveryAttempts` times (a concurrency
 conflict up to `MaxConflictRequeues` times) and then moved to `<subscription>.dead-letter`; it was
 rejected and dropped by the broker before (conflicts were requeued without bound). Because a
 classic queue cannot be redeclared as a quorum queue, the worker queue is now
 `<subscription>.v2`. **Rollout:** deploy — old and new consumers share the exchange and both
 receive every message — then delete the old `<subscription>` queue once it is drained, or it fills
 forever. Needs RabbitMQ 3.8+.
- **Azure Service Bus applies the same bounds.** A handler failure is abandoned for redelivery until
 `MaxDeliveryAttempts` and then dead-lettered with reason `failure` (it was dead-lettered on the
 first failure with the exception type as reason); a conflict is dead-lettered by the framework
 past `MaxConflictRequeues` with reason `conflict` (it was left to the broker's `MaxDeliveryCount`).
 Set the subscription's `MaxDeliveryCount` at least one above the larger bound.
- `AddAzureServiceBus` and `AddAzureServiceBusWithManagedIdentity` also register a
 `ServiceBusAdministrationClient` (try-add) for the advisory limit check.

### Fixed

- The `MediatorCommandWorker` remark said a failing command was dead-lettered; on RabbitMQ it was
 dropped. It is now dead-lettered on both brokers, and the remark and the
 `BusEnvelopeIntegrityMode.Strict` remark say what happens.
- A duplicate stream version on the SQLite test store (`Stratara.Testing.EntityFrameworkCore`) now
 surfaces as `ConcurrencyException`, as it does on PostgreSQL, instead of a bare
 `DbUpdateException`. A test that asserted the old exception type needs the new one.