Working with a legacy Oracle database where the primary key of several tables is a NUMBER(10,1).

Nhibernate appears to be coverting the decimal portion to a string for cache lookup purposes.

The problem is, for example, is for 123456789.1 is sometimes converted to "123456789.1" and sometimes to "123456789.10" when the strings don't match exactly the joins and cache loads fail.

Anybody have a workaround outside of changing the database schema?

The simple solution of multiplying away the fractional part is not workable due to performance (i.e. invalidation of the index).