Question, is there anything more recent than PostgreSQLConfiguration.PostgreSQL83, is that for what, pg 8.3?! Will that be sufficient?! Right now ATM we are talking about at least pg 16+, which I have installed presently.
On Tuesday, June 3, 2025 at 12:27:47 PM UTC-4 Michael W Powell wrote: > Hello, > > I am reviewing pg, NodaTime, and FNH docs, for mappings supporting > Duration, Instant, probably couple of others, but those are the major ones. > > As far as I know, Duration maps to pg interval. Generally analog to dotnet > TimeSpan. > > What is the NH analog for pg timestamp? Generally analoy of dotnet > DateTime, DateTimeOffset. Databases are usually created with data types > TIMESTAMP WITH TIME ZONE clauses. > > In terms of NH PrimitiveType Instant what should we be doing for > PrimitiveClass and ReturnedClass? There are no comments there, so it is > difficult to say. Best guess is types of TimeSpan and Duration, > respectively; or DateTimeOffset and Instant, respectively. Or DateTime, > perhaps, rather than DateTimeOffset. > > Then how do I teach NH (FNH) how to treat those types at a fundamental > level? Or do the maps, types, etc, all get magically reflected into FNH? > > > https://nhibernate.info/blog/2011/01/26/date-time-support-in-nhibernate.html > https://postgresql.org/docs/current/datatype-datetime.html > > As well as comparison with efcore. > > > https://npgsql.org/efcore/mapping/nodatime.html?tabs=ef9-with-connection-string > > Best, > > Michael W. Powell > > -- You received this message because you are subscribed to the Google Groups "Fluent NHibernate" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/fluent-nhibernate/c1cd9258-b9f2-4c56-947e-90a2a22b02a6n%40googlegroups.com.
