Bug in db generation for boolean columns with default value
Posted: 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 :
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?
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
)Is this a known issue? Is there a workaround?