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 fluent-nhibernate+unsubscr...@googlegroups.com.
To view this discussion visit 
https://groups.google.com/d/msgid/fluent-nhibernate/b0001ddd-b949-44a7-9c9c-101e15baacf3n%40googlegroups.com.

Reply via email to