Stratara.EventSourcing.EntityFrameworkCore
4.4.1
Prefix Reserved
See the version list below for details.
dotnet add package Stratara.EventSourcing.EntityFrameworkCore --version 4.4.1
NuGet\Install-Package Stratara.EventSourcing.EntityFrameworkCore -Version 4.4.1
<PackageReference Include="Stratara.EventSourcing.EntityFrameworkCore" Version="4.4.1" />
<PackageVersion Include="Stratara.EventSourcing.EntityFrameworkCore" Version="4.4.1" />
<PackageReference Include="Stratara.EventSourcing.EntityFrameworkCore" />
paket add Stratara.EventSourcing.EntityFrameworkCore --version 4.4.1
#r "nuget: Stratara.EventSourcing.EntityFrameworkCore, 4.4.1"
#:package Stratara.EventSourcing.EntityFrameworkCore@4.4.1
#addin nuget:?package=Stratara.EventSourcing.EntityFrameworkCore&version=4.4.1
#tool nuget:?package=Stratara.EventSourcing.EntityFrameworkCore&version=4.4.1
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 types are mapped for a model that has vector columns; a model without them runs on a plain PostgreSQL server, no vector extension needed. 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 theg) through 3.1.x.AddNpgsqlWriteDbContextFactoryreplaced 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 theg; 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;Unhealthywhen the database cannot be reached.AddOutboxHealthCheck(degradedThreshold?, unhealthyThreshold?)— reports the pending outbox backlog under thependingdata key and escalates toDegraded/Unhealthywhen 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 byProjectionsUnitOfWork.Stratara.Shared— for diagnostics + abstractions + resilience.Npgsql.EntityFrameworkCore.PostgreSQL,EFCore.NamingConventions,Microsoft.AspNetCore.Identity.EntityFrameworkCore,Microsoft.EntityFrameworkCore,Microsoft.Extensions.Diagnostics.HealthChecks,Pgvector.EntityFrameworkCore.
| Product | Versions 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. |
-
net10.0
- EFCore.NamingConventions (>= 10.0.1)
- Microsoft.AspNetCore.Identity.EntityFrameworkCore (>= 10.0.11)
- Microsoft.EntityFrameworkCore (>= 10.0.11)
- Microsoft.Extensions.DependencyInjection (>= 10.0.11)
- Microsoft.Extensions.Diagnostics.HealthChecks (>= 10.0.11)
- Microsoft.Extensions.Hosting (>= 10.0.11)
- Npgsql.EntityFrameworkCore.PostgreSQL (>= 10.0.3)
- Pgvector.EntityFrameworkCore (>= 0.3.0)
- Stratara.Projections (>= 4.4.1)
- Stratara.Shared (>= 4.4.1)
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.4.4 | 90 | 10/10/2026 |
| 4.4.3 | 78 | 10/10/2026 |
| 4.4.2 | 342 | 10/2/2026 |
| 4.4.1 | 402 | 9/29/2026 |
| 4.4.0 | 171 | 9/27/2026 |
| 4.3.1 | 169 | 9/25/2026 |
| 4.3.0 | 332 | 9/23/2026 |
| 4.2.0 | 206 | 9/18/2026 |
| 4.1.1 | 140 | 9/16/2026 |
| 4.1.0 | 133 | 9/16/2026 |
| 4.0.4 | 952 | 9/14/2026 |
| 4.0.3 | 202 | 9/3/2026 |
| 4.0.2 | 623 | 9/3/2026 |
| 4.0.1 | 346 | 9/2/2026 |
| 4.0.0 | 187 | 8/31/2026 |
| 4.0.0-preview.1 | 83 | 8/31/2026 |
| 3.4.0 | 167 | 8/28/2026 |
| 3.3.0 | 148 | 8/25/2026 |
| 3.2.3 | 155 | 8/22/2026 |
| 3.2.2 | 150 | 8/14/2026 |
A release about errors that were not errors. Where two writers insert the same row at once — two
deliveries forgetting a deleted tenant, two activations writing a partition's first checkpoint, two
hosts importing one API key — the framework already recovered, but EF Core had logged the losing
statement at Error first; on PostgreSQL and SQLite the insert now skips a row that is already there.
And a RabbitMQ bus whose broker went away first no longer reports a warning for every subscription it
stops, nor a failed handler for a message it merely could not acknowledge. No migration and no
configuration change is needed.
### Fixed
- **Forgetting a deleted tenant leaves no error in the log when two deliveries race.** A tenant's two
deletion facts arrive in two bundles, so two deliveries of one projection can record the same tenant
at once. The losing insert was caught and the tenant recorded all the same, but EF Core had already
logged the failed statement at Error (`20102` and `10000`), so a customer deletion could leave two
errors in a projection worker's log. On PostgreSQL and SQLite the tenants are now recorded with an
insert that skips a row already there; on other providers the store still retries, and EF Core still
logs the statement that lost.
- **A projection checkpoint's first write, and an API key two hosts import at once, leave no error in
the log.** Two activations of one reader that overlap during a failover can both write a partition's
first checkpoint, and hosts that seed the same key as they boot import it at once. The writer whose
insert lost recovered — it took the other's checkpoint over, or adopted the other's key — but EF Core
had already logged the failed statement at Error. On PostgreSQL and SQLite the insert now skips a row
that is already there, as the record of forgotten tenants does; a checkpoint that another writer
inserted and removed again before it could be taken over is refused with an
`InvalidOperationException`. An import takes that path only where it is the only write on its
context, and then writes the key and its membership in one transaction of its own, outside
`SaveChanges` and its interceptors. An import on a context with unsaved changes or inside a
transaction of the caller's saves through `SaveChanges` as before, and so does a table a consumer
widened with columns the row does not carry, and every other provider: there the writer still
recovers, and EF Core still logs the statement that lost.
- **A RabbitMQ subscription whose broker is already gone stops without a warning.** When a stack stops
its broker before its hosts, a stopping subscription's cancel met a connection that had already
closed, or that closed while the cancel waited for its reply, and every subscription of every host
logged `108_107` at Warning — new in 4.4.0, which made a subscription cancel its consumer before it
closes. A closed connection has no consumer left to cancel, which is where the stop was going, so
this is now logged at Debug as `108_007` (`LogEvents.Messaging.SubscriptionAlreadyClosed`). A cancel
that fails while the connection is still up still warns.
- **A handler that completes after the broker went away is no longer reported as failed.** Its
acknowledgement met a closed channel, and the RabbitMQ bus logged `108_101` at Error although the
handler had succeeded, then tried to reject the message on the same closed channel. It now logs
`108_008` (`LogEvents.Messaging.MessageNotSettledChannelClosed`) at Information: the message could
not be settled, and the broker delivers it again.