MySQL "Create From Existing Database" UInt32 = Int64

[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

[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.

[lc4pro]

Dear Support,

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

Regards

Les

[MariiaI]

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.