Hi, sorry for the cross post in sourceforge until at least I'm sure everyone's looking also here.

I was wondering how to map a decimal and assign the precision in the DB. It doesnt matter how much the precission is in the DB, nhibernate always saves 5 decimal numbers and the rest is filled with zeros.

Am I missing something?

Also, is this possible to do with NullableTypes ?

thanks!

I'm sorry...the bug is related to Nullable types, not de decimal itself.

This raises a new question: how can I pass constructor parameters to nhibernate types in the mapping file. So instead of having a NullableDecimal I can have NullableDecimal(2,9) per example.

I seem to have found the error. I found the following line inside SqlClientDriver.cs. The culprit seem to be here:

case DbType.Decimal:
pps = parameter as ParameterPrecisionScale;
//TODO: remove this hardcoding...
dbParam.Precision = 19;
dbParam.Scale = 5;
break;

Seems like someone missed the TODO

Created http://jira.nhibernate.org/browse/NH-271 about this. I actually believe it's possible, but I need to look at the source.

I have the same problem!

I would want to use the NullableDecimalType with the precision and scale!

Can I declare the precision and scale for nullable decimal type?

Have you find a solution?

I have the same problem

It will be great to make possible to define the NullableDecimal type precision in the mapping files.
The precision can not exceed 5 decimal numbers ...