Stratara.EventSourcing.EntityFrameworkCore
4.4.5
Prefix Reserved
dotnet add package Stratara.EventSourcing.EntityFrameworkCore --version 4.4.5
NuGet\Install-Package Stratara.EventSourcing.EntityFrameworkCore -Version 4.4.5
<PackageReference Include="Stratara.EventSourcing.EntityFrameworkCore" Version="4.4.5" />
<PackageVersion Include="Stratara.EventSourcing.EntityFrameworkCore" Version="4.4.5" />
<PackageReference Include="Stratara.EventSourcing.EntityFrameworkCore" />
paket add Stratara.EventSourcing.EntityFrameworkCore --version 4.4.5
#r "nuget: Stratara.EventSourcing.EntityFrameworkCore, 4.4.5"
#:package Stratara.EventSourcing.EntityFrameworkCore@4.4.5
#addin nuget:?package=Stratara.EventSourcing.EntityFrameworkCore&version=4.4.5
#tool nuget:?package=Stratara.EventSourcing.EntityFrameworkCore&version=4.4.5
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 |
ReadStore/Replay/ |
AddReadModelRestore<TReadContext>(): keeps the read models a replay empties and writes them back when it fails; ReadModelRestoreOptions (section ProjectionReplay:Restore) |
Stratara.EventSourcing.EntityFrameworkCore.ReadStore.Replay |
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.5)
- Stratara.Shared (>= 4.4.5)
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.5 | 0 | 10/14/2026 |
| 4.4.4 | 231 | 10/10/2026 |
| 4.4.3 | 143 | 10/10/2026 |
| 4.4.2 | 355 | 10/2/2026 |
| 4.4.1 | 404 | 9/29/2026 |
| 4.4.0 | 172 | 9/27/2026 |
| 4.3.1 | 170 | 9/25/2026 |
| 4.3.0 | 332 | 9/23/2026 |
| 4.2.0 | 207 | 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 | 358 | 9/2/2026 |
| 4.0.0 | 188 | 8/31/2026 |
| 4.0.0-preview.1 | 83 | 8/31/2026 |
| 3.4.0 | 167 | 8/28/2026 |
| 3.3.0 | 150 | 8/25/2026 |
| 3.2.3 | 157 | 8/22/2026 |
A command can now say whose data its protected fields are. Until now a command's `[EncryptData]` fields were
encrypted for the session that dispatched it, so a session with no tenant could not protect anything and a session
with another tenant protected under the wrong one. Additive and opt-in; no schema change and no migration. One
ordering rule applies once a host starts using it (see *Changed*).
### Added
- **A command can name the owner of its protected fields.** A command that implements the new `INamesDataOwner`
(`Stratara.Abstractions.Security`: `Guid DataOwnerTenantId`, optional `Guid? DataOwnerUserId`) has its
`[EncryptData]` fields encrypted for that owner wherever the framework serializes it — the copy the outbox, the
bus and the Orleans record carry to its handler, and the copy the command audit records — whatever session
dispatched it. It is to a command what `IAggregateCreationEvent` is to a stream's first event. Three cases it
answers: a session with no tenant (an anonymous endpoint, or a saga reacting to a fact one recorded) could not
encrypt a `TenantScoped` field at all outside development; a session with another tenant than the data's owner
encrypted it under that tenant's key, silently, so the real owner's erasure left the audit record readable; and
the two copies of one command were written for different users. For a command that names its owner, both copies
are written for the same tenant and the same user.
- **The audit record of such a command is attributed to the named owner.** Its data-owner tenant and user are the
owner the command names; its actor is the session's, as before. A tenant's view of the command log then holds the
commands that carried its data, whoever issued them, and each record can be read back from its own columns.
- **`CommandEnvelope.DataOwnerTenantId` and `.DataOwnerUserId`** carry the owner beside the session context. They
are set only for a command that names an owner and are omitted from the JSON otherwise; the constructor and
`Deconstruct` are unchanged. The handling host reads the command's protected fields for the owner the envelope
carries and runs the handler under the session it carries.
- **`CommandDataOwner`** (`Stratara.Shared.Security`) is the one resolution every writer and reader of a command
uses, for a host that serializes commands itself.
### Changed
- **The bus-envelope signature covers a named owner.** A signed command does not verify when it is presented with
another data owner, or with its owner removed. A command that names no owner has the canonical form it had before,
so publishers and consumers on either side of this release verify each other's signatures for it and a fleet in
`Strict` mode upgrades without a pass through `Permissive`.
- **Upgrade the hosts that handle commands before a host dispatches a command that names an owner.** A command
worker or silo on an earlier release cannot read the owner. It does not run the handler with the fields emptied:
in `Strict` mode the signature does not verify, otherwise the read fails authentication, and the message is
retried and then kept. Two deployments are the simple order — this release first, the declarations after.
- **Nothing changes for a command that names no owner.** It is serialized, stored, published and signed as before.
That includes a divergence this release states rather than removes: its travelling copy is written for the
session's tenant and the *acting* user, its audit record for the session's tenant and the session's *data-owner*
user — for an ordinary signed-in request, a user and nobody. Aligning that default would re-key every protected
command field in transit and is left to a major version; a command that names its owner is not affected.
### Security
- **An erasure now reaches a command's protected fields where the command names its owner.** `ISubjectEraser`'s
documentation said the command audit log and the outbox are left alone. Their rows still are; what it now also
says is what happens to protected fields in them. A command that names its owner has them under that owner's key
in both places, so the owner's erasure leaves the record of the command with those fields unreadable, and a
command still waiting reaches its handler with them absent.
- **A command that names an empty tenant, or an empty user, as its owner is refused.** It fails with
`ArgumentException` naming the command type where it is recorded and where it is dispatched, and nothing is
recorded or sent. It does not fall back to the session, which would hide a caller's mistake in valid ciphertext
under the wrong tenant's key.
- **Naming an owner authorizes nothing, and the owner is taken as stated.** Nothing compares the named owner
against the session; the handler runs under the dispatching session, and authorization and tenant isolation decide
as they do for any other command. Nothing checks that the named tenant exists either, and key material is created
for it on first use — name an owner the code resolved from something it trusts, never one copied from a request.
- **A command encrypted as a whole does not outlive its owner.** With `[EncryptData]` on individual fields, a
command still waiting when its owner is erased reaches its handler with those fields absent. With `[EncryptData]`
on the class there is nothing left to rebuild: the command is retried and then kept, and its handler does not run.
That is how a command whose session tenant was erased already behaved; it is now stated.