are you using oracle? i had the same issue with oracle since the .net provider calls GetDecimal and should call GetOracleDecimal b/c a "oracledecimal" can be larger than the standard .net decimal.
On 1 Nov., 14:37, Eli <[email protected]> wrote: > Hey guys, > > First of all, new member introduction. I'm Eli, and am working on a > C# application to do spectrophotometry. Hopefully someone might be > able to help with this problem. Bare with me, I inherited this > NHibernate code from someone else, and am trying to learn it as fast > as I can. Here goes... > > In a nutshell, I am using NHibernate to store data locally for a > desktop application. Data is read from a USB device and then put into > the local Database. This works fine. The problem is that when I try > to read the data from the database I get an exception: > > NHibernate.Exceptions.GenericADOException{"could not initialize a > collection: "} with an inner exception of : System.OverflowException > {"Value was either too large or too small for a Decimal."} > > The suspect value is in a StandardDeviation float that we successfully > put into the database, but it seems that it is too large to retrieve. > When I look at the Database using sqlite3 I see that the value of > 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? > > Thanks, > > Eli -- 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.
