Generate Database from Model creates wrong Create Statement

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
Zero-G.
Posts: 398
Joined: Sat 09 Dec 2006 12:20

Generate Database from Model creates wrong Create Statement

Post by Zero-G. » Fri 05 Jun 2015 15:01

Hey

Using your latestes tool
I have a field, which is varbinary(max)
the creation script creates code like this:

Code: Select all

CREATE TABLE dbo.kundenbild (
   ID UNIQUEIDENTIFIER NOT NULL,
   Bild VARBINARY(MAX) DEFAULT ('0x'),
the 0x is not allowed to be surrounded by ' the Statement should be:

Code: Select all

CREATE TABLE dbo.kundenbild (
   ID UNIQUEIDENTIFIER NOT NULL,
   Bild VARBINARY(MAX) DEFAULT (0x),
THX

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Generate Database from Model creates wrong Create Statement

Post by MariiaI » Tue 09 Jun 2015 08:24

We have contacted you by e-mail.

Zero-G.
Posts: 398
Joined: Sat 09 Dec 2006 12:20

Re: Generate Database from Model creates wrong Create Statement

Post by Zero-G. » Tue 16 Jun 2015 15:42

Hey

Did you get my Project? - I have resent it, but still didn't get any Response

THX

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Generate Database from Model creates wrong Create Statement

Post by MariiaI » Thu 18 Jun 2015 07:06

Your letter was blocked by our mail filter for some reason.
We are investigating your project. Are you encountering the same error as described here or any other one?

Also, we have fixed the bug with the quoting default values of the VARBINARY(MAX) and UNIQUEIDENTIFIER columns when performing Update Database From Model and Generate Database Script wizards.
The fix will be included in the next public build of LinqConnect, which we plan to release this week.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Generate Database from Model creates wrong Create Statement

Post by MariiaI » Fri 19 Jun 2015 07:20

The bug with the quoting default values of the VARBINARY(MAX) and UNIQUEIDENTIFIER columns when performing Update Database From Model and Generate Database Script wizards is fixed.
New build of LinqConnect 4.4.775 is available!
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=31997.

Post Reply