Decimals in LinqDataSource.Where

Decimals in LinqDataSource.Where

Postby mr_gorkajuice » Tue 31 Aug 2010 11:16

I’m facing a problem with decimals when constructing a where-clause using LinqDataSource.Where
After constructing the Where-clause, it contains the following bit:

SomeTable.SomeNumber >=0.5 && SomeTable.SomeNumber <=0.6

However, once our Oracle database is queried, DBMonitor reveals that the variables have changed to 5 and 6. More generally speaking, my decimal point is removed, turning 0.5 into 05, and the leading 0 is of course discarded as it’s now irrelevant.
Am I doing something wrong, or is there a problem when using decimals in LinqDataSource.Where?

I’m running on a Danish system, where “,” is normally used for decimal point. However, constructing the Where-clause to read

SomeTable.SomeNumber>=0,5 && SomeTable.SomeNumber<=0,6

… causes run-time errors. So I’m stuck between a decimal point that doesn’t work, and a decimal point that DEFINITELY doesn’t work.

Any suggestions?
Posts: 1
Joined: Tue 31 Aug 2010 11:06

Postby StanislavK » Wed 01 Sep 2010 11:13

Thank you for your report, we've reproduced the issue. We will investigate it and inform you about the results.
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Return to dotConnect for Oracle