About pg dialects INTERVAL NodaTime.Duration etc

[mwpowellhtx]

Hello,

I see that potentially there are pg dialects, which is fantastic.

Specifically, I need to understand from a language level as much as from the database level, what is the dotnet csharp translation for INTERVAL? Which I specifically require as a seamless mapping from EF core to NH core mapping NodaTime.Duration, for starters. Perhaps also talking about NodaTime.Interval and on from there.

Not sure how much HQL level support I would need, just to get the mappings themselves on their feet properly.

Best, and thank you!

[fredericDelaporte]

I guess it should be TimeSpan, but I actually do not know what is that interval type in PostgreSql. There is no mapping for it built in NHibernate. You may add it by providing your own dialect class, if a suitable NHibernate type exists. Otherwise, an user type should be used.

[mwpowellhtx]

Yessir, that is the direction I am headed, my own custom dialect. Just here at the moment learning the ropes as it were, what's working, not working, just from the default dotnet API standpoint. Thanks for the pointers, and the responses! Best 🍻