Connecting MySql With Entity Framework c#-CodePudding

I have a stable program working with local SQL Server, However the client requires online access (with low budget) to the database. So I decided to migrate to MySQL (if you have any suggestion with that)

Now, When I try to create Entity Framework with the MySql server I get this error

I tried couple of things but none of them worked for me. I'm new to MySql

CodePudding user response：

After struggling, here how I solved it.

First, go to Tools -> NuGet Package Manager -> Manage NuGet package ...

Go to "Installed" tab and uninstall all what you have there (In my case was a new project to test connection, so nothing was important there)

Go to "Browse" tab and search and install the following:

* EntityFramework by Microsoft 
* MySql.Data by Oracle 
* MySql.Data.EntityFramework by Oracle

Clean and build solution then add your Entity framework