Stratara.EventSourcing.EntityFrameworkCore
4.1.1
Prefix Reserved
See the version list below for details.
dotnet add package Stratara.EventSourcing.EntityFrameworkCore --version 4.1.1
NuGet\Install-Package Stratara.EventSourcing.EntityFrameworkCore -Version 4.1.1
<PackageReference Include="Stratara.EventSourcing.EntityFrameworkCore" Version="4.1.1" />
<PackageVersion Include="Stratara.EventSourcing.EntityFrameworkCore" Version="4.1.1" />
<PackageReference Include="Stratara.EventSourcing.EntityFrameworkCore" />
paket add Stratara.EventSourcing.EntityFrameworkCore --version 4.1.1
#r "nuget: Stratara.EventSourcing.EntityFrameworkCore, 4.1.1"
#:package Stratara.EventSourcing.EntityFrameworkCore@4.1.1
#addin nuget:?package=Stratara.EventSourcing.EntityFrameworkCore&version=4.1.1
#tool nuget:?package=Stratara.EventSourcing.EntityFrameworkCore&version=4.1.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. 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.1.1)
- Stratara.Shared (>= 4.1.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.3.0 | 0 | 9/23/2026 |
| 4.2.0 | 169 | 9/18/2026 |
| 4.1.1 | 114 | 9/16/2026 |
| 4.1.0 | 113 | 9/16/2026 |
| 4.0.4 | 880 | 9/14/2026 |
| 4.0.3 | 193 | 9/3/2026 |
| 4.0.2 | 614 | 9/3/2026 |
| 4.0.1 | 249 | 9/2/2026 |
| 4.0.0 | 180 | 8/31/2026 |
| 4.0.0-preview.1 | 77 | 8/31/2026 |
| 3.4.0 | 159 | 8/28/2026 |
| 3.3.0 | 136 | 8/25/2026 |
| 3.2.3 | 145 | 8/22/2026 |
| 3.2.2 | 139 | 8/14/2026 |
| 3.2.1 | 141 | 8/2/2026 |
| 3.2.0 | 160 | 7/18/2026 |
| 3.1.7 | 442 | 7/1/2026 |
| 3.1.6 | 572 | 6/22/2026 |
| 3.1.5 | 159 | 6/22/2026 |
| 3.1.4 | 168 | 6/15/2026 |
Correctness fixes for the Orleans execution model ahead of production use. Recorded commands can no longer
reach a bus drain, a durable timer fires once however long its handler runs, and heavy commands are
specified as the exception to the one-writer-per-aggregate promise they always were. The execution-model
reset removes only the host's own checkpoints, and three store-level fixes land for the partition
counter, its backfill and a checkpoint's first write. No schema change; **stop every bus outbox worker
before upgrading hosts that record commands through the execution model**, and register
`AddStrataraIntentStore` on the silos that run the drain.
### Changed
- **Orleans: the execution-model reset removes only the checkpoints of the host's own projections and
sagas.** It removed every checkpoint in the read store, so a reset in one deployment made another
deployment sharing the read store rebuild its projections unasked. The reset now removes the
checkpoints of the projections and sagas registered in the composition it is resolved from, and the
report counts only those. A checkpoint of a projection the host no longer registers stays; nothing
reads it. Resolve the reset from the host's own composition — one that registers no store reader
removes no checkpoint.
- **The documentation states when a read store can be shared.** Checkpoints are keyed by consumer, not
by deployment: deployments sharing a read store need distinct projection names, and at most one of
them runs `AddStrataraSagaGrains`.
- **Orleans: heavy commands are specified as running outside their aggregate's turn and order.** They
always ran in their own bounded pool beside the aggregate's other commands; the specification promised
otherwise. Their hand-over no longer holds the per-aggregate send order either: a command dispatched after
a heavy command for the same aggregate no longer waits for it, and two due heavy commands on one aggregate
no longer hold up the drain's resume pass. Where a heavy command and another command on the same aggregate
both append, the store's version check refuses the later one, which is resumed like any failing command.
- **Orleans: a recorded command is stored under a kind of its own.** No bus outbox drain reads it any more.
Commands recorded under 4.1.0 are still resumed; stop every bus outbox worker before upgrading hosts that
record commands.
### Fixed
- **Orleans: the outbox drain no longer publishes recorded commands to the bus.** It chose between resuming
recorded commands and publishing stored commands by whether the execution model's dispatcher was
registered on its own silo, and the migration guide registers the dispatcher on the API host and the drain
on the silos. Such a silo handed every recorded command — kept ones included — to the bus: commands ran
twice, kept commands came back, the attempt bound did not hold. The drain now resumes recorded commands
wherever an intent store is registered and warns (`117_111`) where recorded commands exist but none is.
Register `AddStrataraIntentStore` on the silos that run the drain.
- **Orleans: a durable timer fires once however long its handler runs.** A handler that outlasted the
reminder call's response timeout was started again by the next tick. A tick that arrives while the same
timer's handler runs now does nothing, and a tick confirms its timer is still registered before firing.
- **Orleans: two writers of the same first checkpoint no longer fail one of them.** When an
activation and its successor overlap during a failover, both can find no checkpoint row and both
insert it; the one that lost to the key threw. It now updates the row the other inserted.
- **Orleans: the partition counter works on a model that does not use snake-case names.** The
interceptor advanced the counter with SQL naming `partition_position` and its columns literally, so
a write context mapping the counter under other names failed every append. It now goes through the
context's model, as the native reader already did.
- **Orleans: the partition-counter backfill positions old entries in the order they were appended.**
It ordered each partition's history by bucket first, so a projection or saga reading across
aggregates saw the facts of one bucket before earlier facts of another. Entries are now positioned
in sequence order, as the event-sourcing-store specification already promised. A store backfilled
under 4.1.0 keeps the positions it was given; the backfill does not reposition entries.