How do I install the MySQL Entity Framework provider?

Question

User-696641838 posted

I am changing host servers for my website that requires me to go from using an SQL to a MySQL database.  This required me to upgrade from 2008 to 2015 Visual Studio and I have used Server Explorer to confirm that there is a valid connection to the MySQL database in the local host.  There appears to be no problem with the code to directly read or remove rows from a table.  But now I need my Entity Framework code that was working fine with SQL to now work with MySQL. 

I was told that this required me to install the MySQL Entity Framework provider via Nuget Package.  I attempted Installing and Updating NuGet Client by using the Command-Line Utility via Direct Download.  The nuget.exe file has been downloaded, but it will only execute for a second and then it terminates.  None of the information that is provided at:  http://lvasquez.github.io/2014/11/18/EntityFramework-MySql/ or https://www.nuget.org/packages/MySql.Data.Entity/ makes any sense to me.  What should I do now?

Maurice

Answer 1

User-821857111 posted

You shouldn't need command line tools. Visual Studio already has an integrated Nuget Client. Go to Tools » Nuget Package Manager and then either choose Package Manager Console and type "Install-Package MySql.Data.Entity" or use the Manage Nuget Packages for Solution option to locate and install the package.

Answer 2

User-696641838 posted

 

Wow!  I thought this was going to be hard, but it was easy with the integrated Nuget Client within Tools of Visual Studio.  Thank you again for your help.  There are no errors now with my Entity Framework code.  But, all of my code that I use for the reader and the removal of table rows now generate errors, which state that the types ‘MySqlConnection’, ‘MySqlCommand’, and ‘MySqlParameter’ exist.  These have nothing to do with Entity Framework, so why are they causing errors now and what must I do now to correct these problems?

 

Maurice

 

Answer 3

User-821857111 posted

You need to start another thread explaining the new issue you are facing.

Answer 4

User-696641838 posted

OK, it shall be done.

Maurice