LinqConnect Professional Version 4.1.197 (28-Feb-2013) - SET NULL for Association not work

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
AKRRKA
Posts: 198
Joined: Thu 26 Jan 2012 15:07
Location: Russia
Contact:

LinqConnect Professional Version 4.1.197 (28-Feb-2013) - SET NULL for Association not work

Post by AKRRKA » Fri 29 Mar 2013 06:34

Hello,

I have a problem.
Use LinqConnect Professional Version 4.1.197 (28-Feb-2013).
When change "Delete Rule" for Association to "SET NULL" and update database (may be and when generate) don`t change rule "On Delete" to "SET NULL" in foreign key into database.
And remains "RESTRICT".
When change to "CASCADE" key changed in database correctly, but i need "SET NULL".

Please fix this issue.
I have more association like this, and so big problem.

PS: Tested with SQLServer and MySQL.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: LinqConnect Professional Version 4.1.197 (28-Feb-2013) - SET NULL for Association not work

Post by MariiaI » Fri 29 Mar 2013 09:16

Thank you for the report. We have reproduced this error. We will inform you when it is fixed.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: LinqConnect Professional Version 4.1.197 (28-Feb-2013) - SET NULL for Association not work

Post by MariiaI » Mon 01 Apr 2013 08:35

The bug with the database script generation for the 'Delete Rule' association property has been fixed. The fix will be included in the next build of LinqConnect. We will inform you when it is available for download.

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

Re: LinqConnect Professional Version 4.1.197 (28-Feb-2013) - SET NULL for Association not work

Post by AKRRKA » Mon 01 Apr 2013 08:58

Could you send me a corrected library generation script.
I have very little time, and I necessary to work much on a big database, manually edit all references impossible.

Thank you.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: LinqConnect Professional Version 4.1.197 (28-Feb-2013) - SET NULL for Association not work

Post by MariiaI » Mon 01 Apr 2013 09:39

We have contacted you via the mail.

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

Re: LinqConnect Professional Version 4.1.197 (28-Feb-2013) - SET NULL for Association not work

Post by AKRRKA » Mon 01 Apr 2013 12:00

I answered from my work e-mail.
On the this support forum, I registered with my personal e-mail.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: LinqConnect Professional Version 4.1.197 (28-Feb-2013) - SET NULL for Association not work

Post by MariiaI » Fri 05 Apr 2013 08:34

The new build of LinqConnect 4.2.222 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 valid subscription only).
For more information please refer to http://forums.devart.com/viewtopic.php?f=31&t=26311

Post Reply