ErikEJ / EFCorePowerTools

Entity Framework Core Power Tools - reverse engineering, migrations and model visualization in Visual Studio & CLI
MIT License
2.18k stars 297 forks source link

DBFirst Reverse: using Mysql as data source causing ArgumentOutOfRangeException #2521

Closed iccfish closed 1 month ago

iccfish commented 1 month ago

After choosing data source, then an exception dialog was shown.

---------------------------
Microsoft Visual Studio
---------------------------
EF Core Power Tools

Table list error: 

System.ArgumentOutOfRangeException: unsupported database type: Mysql (Parameter 'options')

   at IServiceCollection RevEng.Core.ServiceProviderBuilder.AddEfpt(IServiceCollection serviceCollection, ReverseEngineerCommandOptions options, List<string> errors, List<string> warnings, List<string> info) in D:/a/EFCorePowerTools/EFCorePowerTools/src/Core/RevEng.Core.60/ServiceProviderBuilder.cs:line 160

   at async Task<int> EfReveng.Program.Main(string[] args) in D:/a/EFCorePowerTools/EFCorePowerTools/src/Core/efreveng60/Program.cs:line 53

---------------------------
OK 
---------------------------

image

If change EF Core version to EF8, works well as excepted.

ErikEJ commented 1 month ago

@iccfish There is no MySQL provider for EF Core 9 yet, as the error message indicates. Use the EF Core 8 tooling for now (in reality no difference)

ErikEJ commented 1 month ago

@iccfish If you like my free tools, I would be very grateful for a rating/review on Visual Studio Marketplace and/or a one-time or monthly sponsorship

iccfish commented 1 month ago

@iccfish There is no MySQL provider for EF Core 9 yet, as the error message indicates. Use the EF Core 8 tooling for now (in reality no difference)

I think the package Pomelo.EntityFrameworkCore.MySql 9.0.0-9.0.0-preview.1 should support EF Core 9 cause it depends on package 'Microsoft.EntityFrameworkCore.Relational >= 9.0.0-preview.1.24081.2 && <= 9.0.0-preview.1.999999' 😄

iccfish commented 1 month ago

@iccfish If you like my free tools, I would be very grateful for a rating/review on Visual Studio Marketplace and/or a one-time or monthly sponsorship

Roger that. I would like to do that laterly, thanks for your awesome powerful tool 👍

ErikEJ commented 1 month ago

Cool,

ErikEJ commented 1 month ago

I will get that package added in the latest daily!

ErikEJ commented 1 month ago

@iccfish I cannot add it, as the latest daily uses 9.0 RC 1