Hi, I had some similar problem a couple of years ago with an Oracle Database and found no good solution.
The Oracle Data Provider uses a Decimal as intermediate representation in the OracleDataReader even if you call the GetDouble method. I consider that a grave implementation bug because they obviously did not care about value ranges of the different .NET data types. And it tries to return a Decimal if you call the GetValue method of the data reader. And as far as I know, NHibernate uses the GetValue method to retrieve the data of a Find operation. Maybe it's the same situation for your ADO.NET provider. You could use JetBrains dotPeek to have a look at the implementation of your DataReader.GetValue method and check out how the data provider deals with numeric data. Or if you have the source code of your provider, check it out directly. CS On 1 Nov., 20:14, Eli Crane <[email protected]> wrote: > So is it possible to specify the type that we want to read the data into? > We could use a Float. The inner exception indicates that it is trying to > store the number in a Decimal. > > Thanks, > > Eli > > On Tue, Nov 1, 2011 at 10:38 AM, Oskar Berggren > <[email protected]>wrote: > > > > > 2011/11/1 Eli <[email protected]>: > > > StandardDeviation is 3.40282001837566e+38. > > > > Can anyone think of a reason why this would be allowable to be written > > > to the DB, but not readable? > > > According to > >http://msdn.microsoft.com/en-us/library/364x0z75%28v=VS.90%29.aspx > > > decimal have a range up to 10^28. > > > So probably you used something other than decimal, such as float, > > double or string to store it. > > > /Oskar > > > -- > > 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. -- 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.
