Short answer: If it's 0.65 when you store it, and 0.65 when you retrieve it, what is the problem anyway? :-)
Long answer: This has to do with approximate numeric data types and conversion. A float column corresponds to a Double in .NET (real corresponds to Single), so you have an unintended conversion there. Either change the db type to real, the .net type to double, or both to decimal. Diego On Wed, Jan 13, 2010 at 00:38, Brian Sullivan <[email protected]> wrote: > I've got a property on a persistent object that's a float in .NET, > mapped as a System.Single via Fluent NH, to a float column in a SQL > Server database. When I save my entity, I get values in this float > column that are slightly off. Say, if the user enters .65, I get > 0.649999976158142 stored in the database. I've checked the value of > the .NET property in the debugger, and it's got the exact value the > before it's persisted, and also if I retrieve it later. What's going > on here? > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > > >--
You received this message because you are subscribed to the Google Groups "nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to [email protected].
For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
