Devart Forums

Posted: **Fri 11 Sep 2015 10:27**

Hello

Use LinqConnect Professional Version 4.5.816 (20-Aug-2015).

When create database from Entity Developer for create table and field with default value.

Code: Select all

CREATE TABLE `comobjects` (
	`ComObjectId` INT(9) NOT NULL AUTO_INCREMENT COMMENT 'Уникальный идентификатор',
	`TimeZone` SMALLINT(5) NOT NULL DEFAULT '240',
	PRIMARY KEY (`ComObjectId`),
)

But when create from code, with function CreateDatabase (), default value for field don`t create.

Code: Select all

CREATE TABLE `comobjects` (
	`ComObjectId` INT(9) NOT NULL AUTO_INCREMENT,
	`TimeZone` SMALLINT(5) NOT NULL,
	PRIMARY KEY (`ComObjectId`),
)

This is very critical bug for me.
Link to full compare image: http://rghost.ru/7XDgMNs4C

Posted: **Mon 14 Sep 2015 15:05**

Currently, the generation of the default values via CreateDatabase() method is not supported in LinqConnect. We are considering the possibility of adding this support, but we can't tell any timeframe at the moment. We will inform you when any results are available.

JIC: in fact, you can use the "Create Database Script"/"Update Database from Model" wizards in Entity Developer. Please refer to the corresponding topic in the Entity Developer documentation:
1. ORM Support -> LinqConnect -> Synchronizing Model and Database Data -> Updating Database from Model.
2. User Interface Reference -> Generate Database Script Wizard.

Posted: **Tue 15 Sep 2015 07:19**

But that is regression!!!
You have already fixed this error (in version LinqConnect 4.4.453).
See the topic: http://forums.devart.com/viewtopic.php? ... 6&start=30

For me this is a very critical issue.
Please fix this.

Posted: **Tue 15 Sep 2015 07:56**

AKRRKA wrote:But that is regression!!!
You have already fixed this error (in version LinqConnect 4.4.453).
See the topic: http://forums.devart.com/viewtopic.php? ... 6&start=30

This issue has not been fixed earlier.
From the topic you have specified, e.g. our answer on Mon 17 Feb 2014 16:45:

MariiaI wrote:
4) Don`t add comments.
3) Don`t set default value; (Critical issue)
We can't tell any timeframe for fixing these issues at the moment.

Our answer on Fri 07 Mar 2014 09:34:

MariiaI wrote:
1) Foreign keys name different; (Critical issue)
2) Wrong field used in relations. Are mixed up!; (Critical issue)
5) Action for constraints.
Please try the new build of LinqConnect 4.4.453 and tell us about the results.
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=29103.

LinqConnect 4.4.453 doesn't include the fix for the issue related to generating default values for columns via CreateDatabase method. We are considering the possibility of adding this support. We will inform you when any results are available.

Devart Forums

LinqConnect Professional Version 4.5.816 (20-Aug-2015) - Dont create Default value for fields

LinqConnect Professional Version 4.5.816 (20-Aug-2015) - Dont create Default value for fields

Re: LinqConnect Professional Version 4.5.816 (20-Aug-2015) - Dont create Default value for fields

Re: LinqConnect Professional Version 4.5.816 (20-Aug-2015) - Dont create Default value for fields

Re: LinqConnect Professional Version 4.5.816 (20-Aug-2015) - Dont create Default value for fields