The recommended way to persist date/time information by Npgsql is to use NodaTime (https://www.npgsql.org/doc/types/nodatime.html?tabs=datasource). Hence, I'm using it in all my projects.
While reading DateTime from the database seems to work finde, trying to write data results in the field in the database containing negative infinity.
Then I tried to use the typed data context from my project, but then LinqPad complains about not being able to map the "Instant" type.
As NodaTime is recommended by Npgsql, it would be great if there was a way to use it in LinqPad.