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

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
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

Post by MariiaI » Wed 25 Dec 2013 09:30

The bug with wrong order for creation tables with the many-to-many associations via the CreateDatabase() method is fixed. The fix will be included in the next build of LinqConnect. We will inform you when it is available for download.

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

Post by MariiaI » Thu 26 Dec 2013 12:56

New build of LinqConnect 4.4.403 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=28602.

AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

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

Post by AKRRKA » Fri 27 Dec 2013 11:41

OK. Wrong order for creation tables is fix. Thanks.

But already have any problem:
1) Default value; (Critical issue)
2) Foreign key name;
3) Action for constraints. (Critical issue)

Please see to image.
Full link: http://s5.hostingkartinok.com/uploads/i ... 89416a.png
Image

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

Post by MariiaI » Fri 27 Dec 2013 13:17

Thank you for the response.
1) Default value; (Critical issue)
This issue has not been fixed yet. We will inform you when the corresponding build with the fix is available.
2) Foreign key name;
The issue with the difference in generating foreign key names between Entity Developer and CreateDatabase() method has a low priority. We will definitely contact you as soon as any results are available.
3) Action for constraints. (Critical issue)
All delete rules, except "NO ACTION", are generated for the associations via the CreateDatabase() method. The "NO ACTION" delete rule is not generated due to the fact that in MySQL it is equivalent to "RESTRICT" - the MySQL Server rejects the delete or update operation for the parent table if there is a related foreign key value in the referenced table. If the delete rule is not specified, the default action is always set to "RESTRICT".
Please refer to: http://dev.mysql.com/doc/refman/5.0/en/ ... -keys.html

AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

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

Post by AKRRKA » Sat 28 Dec 2013 05:48

1) Ok, waiting. Sometimes it is very critical.
2) Yes this is low priority.
3) Yes, indeed. But still I would like to make it the same way.

AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

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

Post by AKRRKA » Mon 27 Jan 2014 15:09

2) Foreign key name;
All the same, this problem is very critical.
I can not prepare a script to update the database, because I do not know foreign key name.
This is a very serious problem.
Very much I ask as soon as possible to fix all three errors.

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

Post by MariiaI » Fri 31 Jan 2014 13:15

The behaviour is changed: now the CreateDatabase() method uses the same algorithm for naming foreign keys as in Entity Developer. We will inform you when the corresponding build of LinqConnect is available for download.

AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

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

Post by AKRRKA » Mon 03 Feb 2014 07:01

Well, finally!
Only foreign keys?
But what about the default values ​​for fields, comments, action for constraints...?
Or all the same now, one algorithm?

One can try to build 4.4.428?

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

Post by MariiaI » Tue 04 Feb 2014 11:10

The fix related to the foreign keys will be available in the next build of LinqConnect.
1) Default value; (Critical issue)
We can't tell any timeframe for fixing this issue at the moment.
3) Action for constraints. (Critical issue)
This behaviour will be changed in one of the next public builds of LinqConnect.

We will contact you as soon as any news are available.

AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

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

Post by AKRRKA » Tue 04 Feb 2014 14:50

Ok, really looking forward to.
Why not use a single code and logic to create a database both in the Entity Developer? In order to avoid the problem altogether.
There is a possibility that in the future will be constantly revealed differences.

AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

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

Post by AKRRKA » Tue 11 Feb 2014 09:06

Due to incorrect naming foreign key problem is even more complicated. The process of updating such databases has become a horror.
Entity Developer when updating the database from the model does not account for incorrect names, and does not change them for new ones.
Very much I ask take into account this and to do this he compared the names and corrected on the right.

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

Post by MariiaI » Wed 12 Feb 2014 13:24

Entity Developer when updating the database from the model does not account for incorrect names, and does not change them for new ones.
Entity Developer shouldn't detect the changes in foreign key names. The foreign key names are irrelevant for the ORM, the main thing is their structure. Moreover, starting from the next build, which we plan to release this week, some changes in LinqConnect runtime regarding working with foreign key names will be available.
Also, you can use "Recreate Database Tables" option to recreate the database tables so that the foreign key names were correct.
3) Action for constraints. (Critical issue)
We have changed this behavior. The fix will be included in the next public build of LinqConnect.

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

Post by MariiaI » Fri 14 Feb 2014 06:11

New build of LinqConnect 4.4.438 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=28939.

AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

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

Post by AKRRKA » Sat 15 Feb 2014 12:12

LinqConnect Professional Version 4.4.438 (13-Feb-2014)

But already have any problem:
1) Foreign keys name different; (Critical issue)
2) Wrong field used in relations. Are mixed up!; (Critical issue)
3) Don`t set default value; (Critical issue)
4) Don`t add comments.
5) Action for constraints.

Please see to image.

1) Very critical.
Full link
Image

2) No critical.
Full link
Image

LinqConnect Professional Version 4.4.438 (13-Feb-2014) - Problems.zip (256.1 КБ) - http://rghost.ru/52440842
(archive include, full backup scripts, small for diff, images and info)

For me, these issues are very important, they do not allow updating client databases that were created from the program using the command CreateDatabase ()!
Very much I ask fix 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

Post by MariiaI » Mon 17 Feb 2014 13:45

Thank you for the response.
1) Foreign keys name different; (Critical issue)
2) Wrong field used in relations. Are mixed up!; (Critical issue)
5) Action for constraints.
We have reproduced the issue with foreign keys for many-to-many associations. We will inform you when these issues are fixed.
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.

Post Reply