AdaskoTheBeAsT.Dapper.NodaTime.PostgreSql 6.0.0

AdaskoTheBeAsT.Dapper.NodaTime.PostgreSql

PostgreSQL dialect for AdaskoTheBeAsT.Dapper.NodaTime. It registers the NodaTime type handlers and shapes every parameter with the matching NpgsqlDbType in addition to DbType.

Provider client: Npgsql.

Installation

dotnet add package AdaskoTheBeAsT.Dapper.NodaTime.PostgreSql

Usage

using AdaskoTheBeAsT.Dapper.NodaTime.PostgreSql;
using NodaTime;

PostgreSqlDapperNodaTimeSetup.Register(DateTimeZoneProviders.Tzdb);

Call it once during startup. The dialect is public as PostgreSqlNodaTimeConfiguration if you want to pass it to DapperNodaTimeSetup.Register yourself.

Parameter mapping

Reading notes

Npgsql returns DateOnly for date columns and TimeOnly for time columns on modern targets; both are handled, so LocalDate and LocalTime round-trip without extra configuration.

Offset handling

TIMESTAMPTZ stores an instant, not an offset. OffsetDateTime values are therefore normalized to UTC on the way in, and read back with offset zero. When the original offset is part of your domain, persist it separately:

public sealed class Reminder
{
    public LocalDateTime LocalDateTime { get; set; }
    public Offset Offset { get; set; }

    public OffsetDateTime ToOffsetDateTime() => new(LocalDateTime, Offset);
}

Recommended schema

CREATE TABLE Events (
    Id BIGINT PRIMARY KEY,
    CreatedAt TIMESTAMPTZ NOT NULL,     -- Instant
    ScheduledAt TIMESTAMP NOT NULL,     -- LocalDateTime
    EventDate DATE NOT NULL,            -- LocalDate
    StartTime TIME NOT NULL,            -- LocalTime
    StartsAtUtc TIMESTAMPTZ NULL,       -- OffsetDateTime (UTC normalized)
    UtcOffsetSeconds INTEGER NULL,      -- Offset
    RunTimeNanoseconds BIGINT NULL,     -- Duration
    Recurrence VARCHAR(176) NULL,       -- Period
    Calendar VARCHAR(50) NULL,          -- CalendarSystem
    TimeZone VARCHAR(50) NULL);         -- DateTimeZone

Example

using Dapper;
using NodaTime;
using Npgsql;

using var connection = new NpgsqlConnection(connectionString);

await connection.ExecuteAsync(
    "INSERT INTO Events (Id, CreatedAt, EventDate, StartTime) VALUES (@Id, @CreatedAt, @EventDate, @StartTime)",
    new
    {
        Id = 1L,
        CreatedAt = SystemClock.Instance.GetCurrentInstant(),
        EventDate = new LocalDate(2025, 11, 23),
        StartTime = new LocalTime(10, 0),
    });

Target frameworks

net10.0, net9.0, net8.0, net481, net48, net472, net471, net47, net462. Npgsql 10.x is used on .NET 8+ and Npgsql 8.x on .NET Framework targets.

Links

• Repository and full documentation
• Upgrading from 5.x to 6.0
• Core package readme
• MIT License