Devart Forums

When saving decimal fields, the driver round decimals.
Does not allow to save 3.51m, it incorrectly save 4m.

Sample...

CREATE TABLE [test] (
[id] [VARCHAR(36)] NOT NULL,
[data] [NUMERIC(18, 2)] NOT NULL,
CONSTRAINT [] PRIMARY KEY ([id]));

// Clear Table
using (Database db = new Database())
{
foreach(Test test in db.Tests)
{
db.Tests.DeleteOnSubmit(test);
}
db.SubmitChanges();
}

// Create Record
using(Database db = new Database())
{
Test test = new Test() { Id = "1", Data = 3.51m };
db.Tests.InsertOnSubmit(test);
db.SubmitChanges();
}


// Find record
using (Database db = new Database())
{
Test test2 = db.Tests.First();
MessageBox.Show("expected 3.51 save " + test2.Data.ToString());
}

Thank you for the report. We have reproduced this issue. We will investigate it and inform you about the results as soon as possible.

We have fixed the issue with decimal datatype. The fix will be included in the next build of dotConnect for SQLite. We will inform you when it is available for download.

Any idea when new release will be available.
I can not rollback to previous version, because I also use latest version of PostgreSQL driver.
Even if you can email me the dll, will help alot.

Thanks
Riaan

We plan to release the new build of dotConnect for SQLite next week. We will definitely inform you when the new build is available for download.

New build of dotConnect for SQLite 4.6.276 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/sqlite/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=29&t=27459.