LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase (MySQL)

[AKRRKA]

I found many of the critical issues.

The problem appears when create a new database from code calling the CreateDatabase().

When creating a database from Entity Developer and from program code the database are different.

This is a very critical issue for me! In tested now with MySQL.

When use CreateDatabase():

1) Do not create DEFAULT settings.

Code: Select all

-  `IsOut` tinyint(1) NOT NULL DEFAULT '0',
+  `IsOut` tinyint(1) NOT NULL,

2) Foreign keys are created with the wrong names, and for some of the tables are not created (for sample table comschedules_comobjects).

Code: Select all

-  KEY `FK_Users_UserGrants` (`UserGrantId`),
-  KEY `FK_Users_RefUserType` (`UserTypeId`),
-  CONSTRAINT `FK_Users_UserGrants` FOREIGN KEY (`UserGrantId`) REFERENCES `usergrants` (`UserGrantId`) ON DELETE SET NULL,
-  CONSTRAINT `FK_Users_RefUserType` FOREIGN KEY (`UserTypeId`) REFERENCES `refusertypes` (`UserTypeId`) ON DELETE CASCADE
+  KEY `FK_Users_UserGrants_0` (`UserGrantId`),
+  KEY `FK_Users_RefUserTypes_1` (`UserTypeId`),
+  CONSTRAINT `FK_Users_UserGrants_0` FOREIGN KEY (`UserGrantId`) REFERENCES `usergrants` (`UserGrantId`) ON DELETE SET NULL,
+  CONSTRAINT `FK_Users_RefUserTypes_1` FOREIGN KEY (`UserTypeId`) REFERENCES `refusertypes` (`UserTypeId`) ON DELETE CASCADE

An example of a project, database dumps and the differences send to customer support.

[AKRRKA]

I think that the problem with the same type of this issue
http://forums.devart.com/viewtopic.php?f=31&t=28302

How can that be???!!
Why logic is different? Why would you have done in different places in different ways. Why not one logic applied?

PS: I still check with MS SQL, I hope everything is okay.
PPS: I still need SQLite and Oracle.

[AKRRKA]

With MS SQL database looks like that everything is normal.

[MariiaI]

Thank you for the report on this. We will inform you when these issues are fixed.

[MariiaI]

and for some of the tables are not created (for sample table comschedules_comobjects).
.....
An example of a project, database dumps and the differences send to customer support.

We haven't received the sample, with which the issue when foreign keys for some tables are not created, could be reproduced. Please send us the sample again.

[AKRRKA]

I sent by mail to: [email protected]

[MariiaI]

Thank you for the sample project. We are investigating these issues. We will inform you about the results as soon as possible.

[MariiaI]

The issue with creating foreign keys for many-to-many associations has been fixed. The fix will be included in the next build of LinqConnect. We will inform you when it is available for download.

As for the difference in the SQL generation (e.g., the default values and foreign key names), we can't tell any timeframe at the moment for this issue. We will inform you about the results as soon as any are available.

If you are using a Database-First approach, then, if possible, use special tools such as Devart Schema Compare Tools:
http://www.devart.com/dbforge/sql/schemacompare/ http://www.devart.com/dbforge/mysql/schemacompare/
http://www.devart.com/dbforge/oracle/schemacompare/
which generate complete scripts for database migration.

[AKRRKA]

I tested LinqConnect Professional Version 4.4.383 (28-Nov-2013), the error persists.
I use the Model-First.

Really looking forward to fix the problem and SQLite on x64.
For me these problems are very critical and urgent.

Thanks.

[MariiaI]

I tested LinqConnect Professional Version 4.4.383 (28-Nov-2013), the error persists.

The fix for the issue with creating foreign keys for many-to-many associations is not included in the latest build of LinqConnect. It will be available starting from the next public build. We can send you an intermediate build with the fix, which we will prepare in several days. Please contact us specifying your license number in the letter.

and SQLite on x64.

We will inform you about the results as soon as any are available.

[AKRRKA]

...
We can send you an intermediate build with the fix, which we will prepare in several days
...

Thank you. But I need and fix other problems. I'll wait a week and get the build with all the fixes.

[MariiaI]

New build of LinqConnect 4.4.393 is available for download now!
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=28506.

[AKRRKA]

Now everything has don`t working!

MySQL and MS SQL is not created by CreateDatabase ().
Other types have not tried.

Check for a project that I sent you.

Very much I ask urgently fix!
For me, this is very critical. Updates I have made​​, and the time the product thwarted!

[MariiaI]

Thank you for the sample project. We are investigating this issue. We will inform you about the results as soon as any are available.

[AKRRKA]

There is a progress?