Entity Developer 6.12.1419 EF Core wrong field type for MySql

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


PhpMyAdmin table structure view:

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

[Shalex]

Also, check your default mapping for int via Tools > Options > Servers' Options > MySQL.

[SerhiiS]

I am using dotConnect for MySQL v.8.21.2066 (just reinstalled to make sure it is latest one)


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


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

after I added manually mapping int->int32

it started working again. but definitely was never messing with mapping options before. is there any way to compare my mapping setup to default?

[Shalex]

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.

[SerhiiS]

thank you - reset button updated a mapping list and it seems quite different from what I had.

problem fixed.