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:
Entity Developer 6.12.1419 EF Core wrong field type for MySql
Re: Entity Developer 6.12.1419 EF Core wrong field type for MySql
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.
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
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
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?
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?
Re: Entity Developer 6.12.1419 EF Core wrong field type for MySql
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
thank you - reset button updated a mapping list and it seems quite different from what I had.
problem fixed.
problem fixed.