LinqConnect Professional Version 4.4.383 (28-Nov-2013) - Incorrect DEFAULT value for System.Boolean

[AKRRKA]

Hello.

I use one model for many database type.

When generate database from model, for field with type System.Boolean generate incorrect SQL code for DEFAULT value.

If set DEFAULT value to False or True, generate code, like this:
PS: System.Boolean convert to NUMBER(1).

Code: Select all

-- 
-- Creating a table CEDATABASE."SpecialDays" 
-- 
CREATE TABLE CEDATABASE."SpecialDays" (
   "SpecialDaysId" NUMBER(10) NOT NULL,
   "IsAnual" NUMBER(1) DEFAULT False NOT NULL,
   "IsWorkingDay" NUMBER(1) DEFAULT True NOT NULL,
);

Must be:

Code: Select all

   "IsAnual" NUMBER(1) DEFAULT 0 NOT NULL,
   "IsWorkingDay" NUMBER(1) DEFAULT 1 NOT NULL,

For MySQL, PostgreSql, SQLite and MS SQL Server all ok.

Please fix it.
Thanks.

[MariiaI]

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

[MariiaI]

New build of LinqConnect 4.4.403 is available for download now!
It can be downloaded from http://www.devart.com/linqconnect/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=31&t=28602.

[AKRRKA]

I checked and confirm.
Thank you.

Now generated this SQL code:

Code: Select all

   "IsAnual" NUMBER(1) DEFAULT 0 NOT NULL,
   "IsWorkingDay" NUMBER(1) DEFAULT 0 NOT NULL,