Bug in db generation for boolean columns with default value

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
kkara
Posts: 7
Joined: Mon 27 Dec 2010 10:24

Bug in db generation for boolean columns with default value

Post by kkara » Mon 27 Dec 2010 10:39

Hi,

I'm using a Model First approach. When specifying a boolean column in my model and setting a default value (true and false are the only ones permitted), I get an error when generating the database. The SQL generated looks like this :

Code: Select all

CREATE TABLE [dbo].[TableName] (
      [Id] INT NOT NULL IDENTITY,
      [BooleanColumn] BIT NOT NULL DEFAULT false
)
The problem is of course that false is invalid in that context. It should be either 0 or 'FALSE' (quotes included).

Is this a known issue? Is there a workaround?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Mon 27 Dec 2010 18:05

I have just performed a test and the script was generated with a correct value (0).
Could you please upgrade to the latest 6.0.70 build of dotConnect for Oracle?

kkara
Posts: 7
Joined: Mon 27 Dec 2010 10:24

Post by kkara » Tue 28 Dec 2010 14:38

I'm sorry, I should have been more specific concerning my version...

I'm using the trial edition of the Entity Developer v3.0.60. With that version the only choices of database generation are SQL Server 2000, 2005 and 2008 (I'm trying that on 2008).

I am currently evaluating the product to see if it suits our needs of Model First development...

Thanx,
Kostas

kkara
Posts: 7
Joined: Mon 27 Dec 2010 10:24

Post by kkara » Tue 28 Dec 2010 14:41

Hmmm, additionally I should add I'm using Visual Studio 2010, even though this error occurs when I'm using the standalone version of the application (not as a plugin within Visual Studio).

I realize now its a beta version, so I guess there are things that need fixing up.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 29 Dec 2010 10:38

Thank you for the additional information.
I have reproduced the problem. We will let you know as soon as it is fixed.

kkara
Posts: 7
Joined: Mon 27 Dec 2010 10:24

Post by kkara » Sun 16 Jan 2011 11:14

Hi, has this problem been fixed in the new version of Entity Developer?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Mon 17 Jan 2011 15:09

Yes, we have fixed the error in the latest build.
It can be downloaded here (Trial Edition) or from Registered Users' Area (non-Trial Editions).

Post Reply