How to enable migration for EF 6.4 and MySQL C#?
c# ef-migrations entity-framework-6 migration mysql
Question
I tried to enable migrations using the command
Enable-Migrations
But I got the error below, I didn't really understand how to solve it...
I installed all the extensions to make it works.
The error message :
Checking if the context targets an existing database...
No MigrationSqlGenerator found for provider 'MySql.Data.MySqlClient'. Use the SetSqlGenerator method in the target migrations configuration class to register additional SQL generators.
Popular Answer
I assume your project is a .net core application and you are using visual studio.
- Make sure you have Microsoft.Entityframeworkcore.tools install from Nuget Package Manager.
- From your package manager console, you don't need to enable migration as done previously in ef 5
- Just run Add-Migration {MigrationName}
- Run Update-Database to update the database
OR
- if the AppDbContext is in the same project with the startup file
- Run dotnet ef migrations add {MigrationName}
- Run dotnet ef -database update to update the database
OR
- if the AppDbContext is in the different project, Open the containing project root directory from the command line
- Run dotnet ef migrations add {MigrationName} --s ../{startupproject}/{startupproject.csproj}
- Run dotnet ef -database update to update the database --s ../{startupproject}/{startupproject.csproj}
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
