Page 1 of 1

MySQL "Create From Existing Database" UInt32 = Int64

Posted: Mon 23 Dec 2013 00:15
by lc4pro
Dear support,

I am facing an issue when creating entities from an existing MySQL Database, where the server data type is being picked up correctly as "INT(10) UNSIGNED NOT NULL", however the system type created for the entity is System.Int64, which is incorrect.

I am using the latest version, at the time of writing, 4.4.393

Please can you assist with this anomaly

Regards

Les Brinkworth

Re: MySQL "Create From Existing Database" UInt32 = Int64

Posted: Mon 23 Dec 2013 14:07
by MariiaI
Unsigned int is mapped to long(System.Int64) by default. Please refer to:
http://www.devart.com/linqconnect/docs/ ... pping.html

You can change the default mapping with these steps:
- open Tools -> Entity Developer -> Options -> Server Options -> MySQL;
- set the .NET type you want to use for the Server Type 'UNSIGNED INT';
- make another changes in the mapping if necessary;
- click 'OK' to save the changes;
- recreate your model.

Please tell us if this helps.

Re: MySQL "Create From Existing Database" UInt32 = Int64

Posted: Tue 24 Dec 2013 22:25
by lc4pro
Dear Support,

Thank you for the reply. Your suggestion has resolved the issue.

Regards

Les

Re: MySQL "Create From Existing Database" UInt32 = Int64

Posted: Wed 25 Dec 2013 06:16
by MariiaI
Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.