nhibernate-core | NHibernate Object Relational Mapper

I am trying to understand domain-driven design. The example program I am following uses NHibernate. It has an Entity base class as follows:

Is there any way to make query over joins on different nullable foreign key?

Release notes: https://github.com/nhibernate/nhibernate-core/blob/5.2.4/releasenotes.txt#L103

• A collection mapped with a property-ref will no more support being accessed when the referenced property is null. It will throw. Previously, the collection was not throwing but was always loaded empty.

HasMany(m => m.SomeChildrenList).PropertyRef("Property"); => exception is thrown since Property can be null in database.

We recently migrated from nHibernate v4.x to v5.3.9 and we started to have problems with date time fields. After long analysis I find out that problem caused by DateTime.MaxValue which we using for no date value. Before migration the date was concatenated and stored to database without miliseconds. After upgrade the value is stored in the Oracle DB but reading of date time stamp field is failing for Oracle but not for Microsoft SQL server. The error stack trace:

I've wasted almost a whole day trying to make NHibernate log messages via NLog.Web.AspNetCore for an ASP.Net Core project – to no avail. The only example I could find is hidden deep inside the NHibernate Git repository, but it doesn't work with modern versions of the Microsoft logging libraries. Not to mention it's a really skectchy solution, given that I'd have to copy/paste the two auxiliary classes in that folder to manually bridge the loggers and logger factories between the Microsoft world and the NHibernate world.

Is there any sane, modern, elegant solution (or NuGet package) I didn't manage to identify? I feel I'm missing something simple here, but for the life of me, I don't seem able to make it work.

For clarity, I'm looking for a way to pipe NHibernate's own log messages through NLog, not to persist NLog's messages to a database using NHibernate.