How to use formula property in NHibernate mapping

Question

My question is how to use the formula property that should be used in the SQL where clause. In particular, I would like to use (datepart (hh, getdate ())) as the formula and the resulting SQL, which I expect

Select select_list from table_name where (datepart (hh, getdate ())) <17

But I saved the where clause as follows:

where (this_0_.hh, getdate ())) <= 17

I'm not sure why an alias is inserted before the "hh" date part.

Any help on how to get this when an offer of law is much appreciated!

Thank.

Answer 1

, , hh ( MS , , 'hh' )

( gethour), datepart(hh, getdate()).