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

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

Postby AKRRKA » Fri 22 Nov 2013 09:25

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.
Last edited by AKRRKA on Wed 12 Mar 2014 11:44, edited 4 times in total.
AKRRKA
 
Posts: 194
Joined: Thu 26 Jan 2012 15:07
Location: Russia

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

Postby AKRRKA » Fri 22 Nov 2013 09:32

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
 
Posts: 194
Joined: Thu 26 Jan 2012 15:07
Location: Russia

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

Postby AKRRKA » Fri 22 Nov 2013 09:53

With MS SQL database looks like that everything is normal.
AKRRKA
 
Posts: 194
Joined: Thu 26 Jan 2012 15:07
Location: Russia

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

Postby MariiaI » Fri 22 Nov 2013 14:55

Thank you for the report on this. We will inform you when these issues are fixed.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

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

Postby MariiaI » Mon 25 Nov 2013 09:02

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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

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

Postby AKRRKA » Mon 25 Nov 2013 10:15

I sent by mail to: support@devart.com
AKRRKA
 
Posts: 194
Joined: Thu 26 Jan 2012 15:07
Location: Russia

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

Postby MariiaI » Mon 25 Nov 2013 12:38

Thank you for the sample project. We are investigating these issues. We will inform you about the results as soon as possible.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

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

Postby MariiaI » Fri 29 Nov 2013 15:08

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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

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

Postby AKRRKA » Mon 02 Dec 2013 12:45

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.
AKRRKA
 
Posts: 194
Joined: Thu 26 Jan 2012 15:07
Location: Russia

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

Postby MariiaI » Mon 02 Dec 2013 13:45

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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

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

Postby AKRRKA » Thu 05 Dec 2013 07:34

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.
AKRRKA
 
Posts: 194
Joined: Thu 26 Jan 2012 15:07
Location: Russia

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

Postby MariiaI » Fri 13 Dec 2013 06:17

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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

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

Postby AKRRKA » Fri 13 Dec 2013 13:08

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!
AKRRKA
 
Posts: 194
Joined: Thu 26 Jan 2012 15:07
Location: Russia

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

Postby MariiaI » Mon 16 Dec 2013 06:17

Thank you for the sample project. We are investigating this issue. We will inform you about the results as soon as any are available.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

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

Postby AKRRKA » Wed 25 Dec 2013 09:20

There is a progress?
AKRRKA
 
Posts: 194
Joined: Thu 26 Jan 2012 15:07
Location: Russia

Next

Return to LinqConnect (LINQ to SQL support)