LinqConnect Professional Version 4.5.1024 (07-Jul-2016) - Cannot convert System.UInt32' to MySQL type 'MySqlType.Int'

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.5.1024 (07-Jul-2016) - Cannot convert System.UInt32' to MySQL type 'MySqlType.Int'

Post by AKRRKA » Mon 29 May 2017 12:27

LinqConnect Professional Version 4.5.1024 (07-Jul-2016) - Cannot convert parameter value of type 'System.UInt32' to MySQL type 'MySqlType.Int'.

Hello,

I have any new error. Cant add max value for UInt32 as 4294967295 from code.
With SQL command all good added.

Code: Select all

INSERT INTO `crmdemo`.`users` (`UserId`, `Name`, `Discount`) VALUES ('2', 'Admin', '4294967295');
Column `Discount` generate from model and is:

Code: Select all

  `Discount` int(9) unsigned NOT NULL,
For clarity, I gave a simple example.
In the archive, the source code, database and addition information.

Example - 2017.05.29.7z
http://rgho.st/6lwjNTBX5 - Link updated!
https://www.solidfiles.com/v/jex8rRmVPVPGm - Mirror
md5: 4cd2c3bc5876001aa9fb0dd97e84b954 *Example - 2017.05.29.7z

PS: We are still planning a license renewal so I can only check on the version available to me.
Please check the error on the current version.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: LinqConnect Professional Version 4.5.1024 (07-Jul-2016) - Cannot convert System.UInt32' to MySQL type 'MySqlType.Int'

Post by Shalex » Thu 01 Jun 2017 13:11

Thank you for the test project.

We have reproduced the error with v4.7.1249 (25-May-17) as well and will notify you when the bug is fixed.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: LinqConnect Professional Version 4.5.1024 (07-Jul-2016) - Cannot convert System.UInt32' to MySQL type 'MySqlType.Int'

Post by Shalex » Wed 28 Jun 2017 13:24

The bug with using unsigned integer parameters is fixed (MySQL): viewtopic.php?f=31&t=35593.

Post Reply