Page 1 of 3
LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase (MySQL)
Posted: Fri 22 Nov 2013 09:25
by 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.
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Fri 22 Nov 2013 09:32
by 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.
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Fri 22 Nov 2013 09:53
by AKRRKA
With MS SQL database looks like that everything is normal.
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Fri 22 Nov 2013 14:55
by MariiaI
Thank you for the report on this. We will inform you when these issues are fixed.
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Mon 25 Nov 2013 09:02
by 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.
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Mon 25 Nov 2013 10:15
by AKRRKA
I sent by mail to:
[email protected]
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Mon 25 Nov 2013 12:38
by MariiaI
Thank you for the sample project. We are investigating these issues. We will inform you about the results as soon as possible.
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Fri 29 Nov 2013 15:08
by 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.
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Mon 02 Dec 2013 12:45
by 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.
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Mon 02 Dec 2013 13:45
by 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.
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Thu 05 Dec 2013 07:34
by AKRRKA
MariiaI wrote:
...
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.
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Fri 13 Dec 2013 06:17
by 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.
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Fri 13 Dec 2013 13:08
by 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!
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Mon 16 Dec 2013 06:17
by 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.
Re: LinqConnect Professional Version 4.4.374 (14-Nov-2013) - Many problems with CreatDatabase
Posted: Wed 25 Dec 2013 09:20
by AKRRKA
There is a progress?