Bug in db generation for boolean columns with default value

kkara · 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 · 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 · 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 · 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 · 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 · Post by **kkara** » Sun 16 Jan 2011 11:14

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

AndreyR · 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).