Lyo.EntityReference.Postgres 1.0.9

Lyo.EntityReference.Postgres

Entity Framework Core building blocks for relation rows (subject/actor associations) and source link rows (import provenance) on PostgreSQL.

Column shapes

Relations. Subject/actor endpoints, persisted as legacy for_entity_* / from_entity_* names:

Endpoint columns are nullable at the DB level. Stores and EntityRelationValidation enforce both endpoints.

Source provenance. Inline on parent rows, same pattern as relations on comment:

When to use which base

Index strategy

• Partial unique on (tenant_id, for_entity_*, from_entity_*) where deleted_at IS NULL
• Tenant lookups on subject and actor endpoints, plus context, created_at, and filtered expires_at

Types

• EntityRelationEndpointConfigurationExtensions.ConfigureEntityRelationEndpointColumns. Maps subject/actor columns to for_entity_* / from_entity_*.
• EntitySourceLinkConfigurationExtensions.ConfigureEntitySourceColumns. Inline source columns + lookup index. ConfigureEntitySourceDerivedColumns maps Id and LocallyModifiedAt on derived aggregates.
• EntitySourceConfiguration<TEntity>. Shared source column names/types and indexes. Subclass per module. Optional. Modules may call extensions directly.
• EntityRelationConfiguration<TEntity>. Shared relation column names/types and indexes. Subclass per module.
• EntityRelationOptionalActorExtensions.MapOptionalActorColumns. Endpoint columns plus nullable tenant_id.
• EntityRelationMapping / EntitySourceMapping. Domain to EF mapping for endpoints and provenance records.
• EntityRefModuleDbContext. Override SaveChanges / SaveChangesAsync to set CreatedAt to UTC for new EntityRelationEntityBase entities when still default.
• EntityRefPostgresStoreBase. DI-friendly base for stores. Resolves EntityRefOptions, holds IEntityRefActionInterceptor pipeline, exposes ResolveTenant and RunInterceptorsAsync.
• EntityRefPostgresStoreHelpers. WhereActive, WhereTenant (for EntityRelationEntityBase), RunInterceptorsAsync.
• EntityRelationOptionalActorHelpers. WhereTenant and WhereTenantOrSystem for the optional-actor base.

Typical module wiring

• Define an EF entity inheriting EntityRelationEntityBase (relations) or EntitySourceEntityBase / EntitySourceDerivedEntityBase (inline provenance).
• Implement IEntityTypeConfiguration<T> inheriting EntityRelationConfiguration<T> or call ConfigureEntitySourceColumns, then map module-specific columns/indexes after ToTable / HasKey.
• Use EntityRefModuleDbContext (or replicate StampCreatedAtUtc logic) so created_at is populated automatically.
• In the store layer, map EntityRef to string columns via EntityRefPersistedGuid.PersistedEntityId() when callers still pass Guid values in EntityRef.EntityId.

Debugging

EntityRelationEntityBase and EntityRelationOptionalActorBase implement [DebuggerDisplay(...)] and ToString() for inspection in the debugger and logs.

Tenancy

Per-feature tenancy policy is configured via TenancyOptions on each Postgres*Options, for example PostgresFavoriteOptions.Tenancy. The store resolves caller-supplied Guid? tenantId through TenancyResolver.Resolve before reads and writes:

If a per-feature TenancyOptions.Mode is unset it inherits EntityRefOptions.Mode (default SingleTenantDefault). The same fallback applies to DefaultTenantId.

EntityRefPostgresStoreBase rejects SystemOnly at construction time for stores that map to a non-nullable tenant_id column. Pass requiresNonNullTenant: false from the base ctor for stores backed by EntityRelationOptionalActorBase (or any nullable-tenant entity).

Tenancy in appsettings.json

{
  "EntityRef": {
    "Mode": "SingleTenantDefault",
    "DefaultTenantId": "00000000-0000-0000-0000-000000000000"
  },
  "PostgresAudit": { "Tenancy": { "Mode": "MultiTenantStrict" } },
  "PostgresChangeTracker": { "Tenancy": { "Mode": "SystemOnly" } },
  "PostgresFavorite": { }
}

Bind EntityRefOptions once at the host with AddEntityRefOptionsFromConfiguration. Each module's Extensions.cs binds its own Postgres*Options section.

See also

• Lyo.EntityReference.Models. EntityRef, EntityRelationRow, EntitySourceRecord, EntityRelationValidation, EntitySourceValidation, composite encoding, JSON converter, and interceptors.

Dependencies

Generated from ProjectReference / PackageReference (same model as docs/Lyo.ProjectGraph.html).

• Lyo.EntityReference.Models (direct, lyo)
• Lyo.Postgres (direct, lyo)
• Microsoft.Extensions.DependencyInjection.Abstractions 10.0.5 (direct, microsoft)
• Microsoft.Extensions.Options.ConfigurationExtensions 10.0.5 (direct, microsoft)
• Lyo.Common (transitive, lyo)
• Lyo.Exceptions (transitive, lyo)
• Microsoft.EntityFrameworkCore 10.0.5 (transitive, microsoft)
• Microsoft.EntityFrameworkCore.Design 10.0.5 (transitive, microsoft)
• Microsoft.EntityFrameworkCore.Relational 10.0.5 (transitive, microsoft)
• Microsoft.Extensions.Hosting.Abstractions 10.0.5 (transitive, microsoft)
• Microsoft.Extensions.Logging.Abstractions 10.0.5 (transitive, microsoft)
• Microsoft.Extensions.Options 10.0.5 (transitive, microsoft)
• Npgsql.EntityFrameworkCore.PostgreSQL 10.0.3 (transitive, third-party)
• System.Memory 4.6.3 (transitive, microsoft, netstandard2.0)
• System.Text.Json 10.0.5 (transitive, microsoft, netstandard2.0)