Last post May 29, 2017 01:50 AM by EvenMa
May 24, 2017 10:00 AM|mjkhan|LINK
I have an application which is using EntityFramework, Version=22.214.171.124 for Sql Server 2008 R2 and its working,but now I want to include the mySql Database connection(Entity Framework) but when doing it says: "Your project references the latest version
of Entity Framework; however, an Entity Framework database provider compatible with this version could not be found for your data connection. Exit this wizard, install a compatible provider, and rebuid your project before performing this action".
I have installed mysql-for-visualstudio-1.2.7 first and then mysql-connector-net-6.9.9. I can access the remote database using mysql workbench, but unable to add here in VS 2013 Prof.
Actually I want to access entities of the mysql databases using database first approach. Well my application is MVC 5
May 25, 2017 06:00 AM|EvenMa|LINK
According to your description ,could your database was backed up from the old version and then restored to the new version in MySql?
You could try to execute the following command in shell , and then restart your MySql service.
mysqlcheck -u root -p --check-upgrade --all-databases --auto-repair
If you have any other questions, please feel free to contact me any time.
May 25, 2017 06:06 AM|mjkhan|LINK
As far as I remember, we have not restored to the new version, we did backup and restored on the same version of MySql.
May 25, 2017 09:22 AM|EvenMa|LINK
See the following error message in your error picture:
Created with MySql 50077,now running 50166,Please use mysql_upgrade to fix this error.
That’s mean the version has been changed , you could execute the command of mysql_upgrade to fix this error(mysqlcheck also could fix this error).
You could run it under the mysql installation path’s bin directory such like the following command:
C:\Program Files\MySQL\MySQL Server 5.7\bin> mysqlcheck -u root -p --check-upgrade --all-databases --auto-repair
May 28, 2017 05:14 AM|mjkhan|LINK
Let me ask you something mysql_upgrade will update/upgrade my mysql engine, because I can access mysql databases using workbench remotely and query the tables in them. The problem is with VS 2013 only when trying to add as entity framework.
Should I still run the tool, because I don't want disturb any other service/mysql hence its running for asterisk(FreePBX Server).
May 29, 2017 01:50 AM|EvenMa|LINK
I think there has some different between use EF and workbench to access the database ,EF might need to access some system components to generate code, in your case ,it occurred the error when reading mysql.proc .
This tool will only affect your database ,that's won't affect your database engine.
If you has some worry about it ,you can back up the database before run this tool.