Lyo.Postgres 1.0.0

Lyo.Postgres

Shared PostgreSQL migration plumbing for Lyo libraries that ship their own EF Core schema (Audit, Email, ChangeTracker, EntityReference, etc.). The package is a thin IHostedService that runs DbContext.Database.MigrateAsync at host startup when the consumer’s options opt in.

Out of scope: this package does not ship health checks, design-time IDesignTimeDbContextFactory helpers, or connection-string builders. Those live in the consumer > libraries (e.g. Lyo.Audit.Postgres, Lyo.Email.Postgres) when needed.

Examples

Usage

using Lyo.Postgres;
using Microsoft.Extensions.DependencyInjection;

public sealed class AuditDbOptions : IPostgresMigrationConfig
{
    public string ConnectionString { get; init; } = "";
    public bool EnableAutoMigrations { get; init; }
    public string Schema { get; init; } = "audit";
}

services.Configure<AuditDbOptions>(configuration.GetSection("Audit:Postgres"));
services.AddPostgresMigrations<AuditDbContext, AuditDbOptions>();

Public API

The hosted service activates a TContext instance via Activator.CreateInstance(typeof(TContext), dbContextOptions), so each consumer DbContext must expose a public constructor that takes a single DbContextOptions<TContext>. The migrations history table is stored in the schema returned by IPostgresMigrationConfig.Schema as "<schema>"."__EFMigrationsHistory".

StartAsync short-circuits when EnableAutoMigrations is false. If the flag is true, both ConnectionString and Schema are required (whitespace throws via Lyo.Exceptions.ArgumentHelpers).

Usage

• The hosted service resolves IOptions<AuditDbOptions>.
• If EnableAutoMigrations is false, it returns immediately.
• Otherwise it constructs an AuditDbContext with UseNpgsql(connectionString, opt => opt.MigrationsHistoryTable("__EFMigrationsHistory", schema)).
• It executes CREATE SCHEMA IF NOT EXISTS "<schema>" (the schema name is escaped by doubling embedded " characters before interpolation).
• It runs Database.MigrateAsync(ct).

Consumers

• Lyo.Audit.Postgres
• Lyo.Email.Postgres
• Lyo.ChangeTracker.Postgres
• Lyo.EntityReference.Postgres
• Lyo.FileMetadataStore.Postgres

Dependencies

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

• Lyo.Exceptions — (direct, lyo)
• Microsoft.EntityFrameworkCore 10.0.5 — (direct, microsoft)
• Microsoft.EntityFrameworkCore.Design 10.0.5 — (direct, microsoft)
• Microsoft.EntityFrameworkCore.Relational 10.0.5 — (direct, microsoft)
• Microsoft.Extensions.Hosting.Abstractions 10.0.5 — (direct, microsoft)
• Microsoft.Extensions.Options 10.0.5 — (direct, microsoft)
• Npgsql.EntityFrameworkCore.PostgreSQL 10.0.3 — (direct, third-party)