It is wierd, since I am following this bug from the times of pre Enterprise Library Microsoft Data Access Application block. 2 years ? They did not fix it until now. I'm not sure what the problem is, but Decimal type parameter, added with AddOutParameter to the command parameter collection does not scale. Sure there are workarounds but it is sad to see it over and over again.
Update: just look at the sources - AddOutParameter calls AddParameter and passes scale = 0 hardcoded.
Thursday, March 30, 2006 2:22 AM