Page 1 of 1

Entity Developer 6.12.1419 EF Core wrong field type for MySql

Posted: Wed 16 Feb 2022 20:04
by SerhiiS
Hello I started to have issue with Entity Developer 6.12.1419. For some reason it assign "string" type for some of the fields when I adding table to the diagram view from the database explorer.
I noticed that it is mostly happen to INT fields. Timestamp working ok (converted to DateTime).

for this example I used Database first, empty model. EF Core 6 / .Net 6 with all default settings.

Entity Developer Diagram view:
Image

PhpMyAdmin table structure view:
Image

Re: Entity Developer 6.12.1419 EF Core wrong field type for MySql

Posted: Thu 17 Feb 2022 17:26
by Shalex
We cannot reproduce the problem with dotConnect for MySQL.

Please specify the name and version of the provider you are using with Entity Developer. The list of supported providers for MySQL is available at https://www.devart.com/entitydeveloper/ ... ility.html.

Re: Entity Developer 6.12.1419 EF Core wrong field type for MySql

Posted: Thu 17 Feb 2022 17:28
by Shalex
Also, check your default mapping for int via Tools > Options > Servers' Options > MySQL.

Re: Entity Developer 6.12.1419 EF Core wrong field type for MySql

Posted: Thu 17 Feb 2022 18:32
by SerhiiS
I am using dotConnect for MySQL v.8.21.2066 (just reinstalled to make sure it is latest one)
Image

never actually checked the default mapping before so not quite sure if it correct or not (screenshot has most of numeric related types):
Image

is there mapping settings file anywhere to check if it was modified or damaged?

after I added manually mapping int->int32
Image
it started working again. but definitely was never messing with mapping options before. is there any way to compare my mapping setup to default?

Re: Entity Developer 6.12.1419 EF Core wrong field type for MySql

Posted: Sat 19 Feb 2022 11:55
by Shalex
SerhiiS wrote: Thu 17 Feb 2022 18:32 is there any way to compare my mapping setup to default?
You can press Reset in the Options dialog box from your first screenshot to restore default mapping rules: https://www.devart.com/entitydeveloper/ ... rules.html.

Re: Entity Developer 6.12.1419 EF Core wrong field type for MySql

Posted: Sat 19 Feb 2022 17:04
by SerhiiS
thank you - reset button updated a mapping list and it seems quite different from what I had.

problem fixed.