Hi, I was trying to use the formula feature in a property and was unable to do a query with order by DESC or select TOP 1 because NH kept replacing these functions with the internal table name for the class...

Is there a way to indicate to hibernate that those commands are not ment to be replaced?

If you're using HQL, the order by clause should work fine.

"... order by object.property desc"

If you only want the first result, then use the SetMaxResults(1) method.

I realize I could do it with HQL, but I had the problem using the formula in the HBM files with a derived property.

With derived properties you can input a SQL statement to produce the desired property, but when I use order by or TOP it get's rendered incorrectly.