Recently i am trying to developing n-tier asp.net mvc application using Entity Framework with MySQL as the backend database. I wanted to use latest EntityFramework ie 22.214.171.124 version, so i downloaded sqlconnector package through "Nuget package Installer". These are the libraries that it installed for me:
I somehow sensed that I am not using the right version of
EF tools for Visual Studio 2013
with corresponding version of MYSQL server installation and mysqlconnector for .net. So i downloaded and compared several versions of EF tools, MYSQL installer and MYSQL(Nuget package) for entity framework and finally found the right combination as follows:
As it worked for me , i think mysql.data dll version and mysqlconnector for net that comes with MYSQL installer should match , i have them highlighted here in picture:
After the proper installation ,i finally got EDMX diagram loaded fully and correctly upon creating one.
P.S: after every un-installation of MYSQL server version that did not work for me, I used the useful tool (Advanced_Uninstaller11.exe) to clean all left out registry entries and here is the download link for the tool enter link description here
I Hope that I have explained it clearly of the problem and its resolution. I could not make any of the above points or scenario clear, hope you would comment on it and i would try to explain more and better.
And Thank you @ErikEJ for your continued support on the problem.