Search code examples
mysqlasp.net-core-3.0entity-framework-core-3.0

Configure MySQL with EFcore 3.0

I just started with Authentication and authorization for SPAs of Dotnet core 3.0 by using

dotnet new angular -o <output_directory_name> -au Individual

and it created a new project with Angular as a client side app and ASP.net core as a backend. Now I want to use MySQL with this template.

I have tried using two providers for this

  1. MySql.Data.EntityFrameworkCore
  2. Pomelo.EntityFrameworkCore.MySql

but both of them are not supported with Entityframework core 3.0 and asking me to downgrade to Entityframework core 2.2. When I downgraded to Entityframework core 2.2 another package named Microsoft.AspNetCore.ApiAuthorization.IdentityServer starts breaking as it requires Entityframework core version 3.0 and above.

Can somebody please tell me how to setup this template of Authentication and Authorization for SPAs for MySQL?

Solution

  • It turned out I had to wait some time for Pomelo Entity Framework Team to release the .NET Core 3.0 Supported version which is available now. All the other things are now working as expected.