How to log NHibernate SQL to ASP.NET Core loggers by @gpeipman gunnarpeipman.com

Logging down SQL created by ORM is useful when debugging new features of application. SQL logging in NHibernate is a little bit tricky and not so straightforward as it is with Entity Framework Core.