Updated Model from Database Keeps say NULL has changed

[HadleyHope]

Every time I update the model from the database I get a lot of columns being marked as changed when they have not been modified at all. The message is the same:

Code: Select all

   DefaultValue(old="NULL", new='NULL') was changed.

This message for example was shown for the UnicodeDecimal column of the following table:

CREATE TABLE Currency (
Code char(3) PRIMARY KEY NOT NULL,
Name nvarchar(100) NOT NULL,
ShortName nvarchar(100),
UnicodeDecimal nvarchar(20) DEFAULT NULL,
UserDefined boolean NOT NULL DEFAULT 0
);

CREATE INDEX CurrencyIdx_NameCode
ON Currency
(Name, Code, UserDefined);


dotConnect for SQLite Version: 4.6.301.0
Server Version: 3.7.17
PRAGMA synchronous=NORMAL
PRAGMA journal_mode=WAL

[Shalex]

Thank you for your report. We have reproduced the issue and will notify you when it is fixed.

[Shalex]

The bug with detecting default NULL values by the Update Model From Database wizard is fixed. We will post here when the corresponding build of Entity Developer is available for download.

[Shalex]

New build of Entity Developer 5.5.196 is available for download now!
It can be downloaded from http://www.devart.com/entitydeveloper/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=32&t=27973.