Tuesday, July 29, 2014

Solve: Your project references the latest version of Entity Framework (for MySQL) in Visual Studio 2013

The error message while trying to create a ADO.net Entity Data Model ( Entity Framework 6 ) for MySql Database in Microsoft Visual Studio 2013

"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. if you have already installed a have already installed a comptible provider, ensure you have rebuilt your project before performing this action. Otherwise, exit this wizard, install a compatible provider, and rebuid your project before performing this action."

Error Window


Solution: 


1. Before start solution steps, check the following Pre-requirements:

2. Registering EF providers
  • Remove the default entityFramework tag in App.config or Web.config
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>
  • Add the following entityFramework tag:
  <entityFramework>
    <defaultConnectionFactory type="MySql.Data.Entity.MySqlConnectionFactory, MySql.Data.Entity.EF6" />
    <providers>
      <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" />
    </providers>
  </entityFramework>

MySqlProviderServices


3. Adding The following References to your project or check it versions:
  • MySql.Data.dll
  • MySql.Data.Entity.EF6.dll
  • MySql.Web.dll
     They should reside the following folders:
  • C:\Program Files\MySQL\MySQL Connector Net 6.8.3\Assemblies\v4.5 (32bit windows)
  • C:\Program Files (x86)\MySQL\MySQL Connector Net 6.8.3\Assemblies\v4.5 (64bit windows)

MySQL Connector


4. Rebuild your project

Rebuild

5. Re-perform your steps of add ADO.NET Entity Data Model

62 comments:

  1. I've been to just about every web reference on this issue and am still stumped. Machine.config, packages.config, App.config all to latest (6.9.4). The 3 dll's were also copied to C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies. Can't believe how hard this is to diagnose. We need a list of all "keys" being checked by that dialog.

    ReplyDelete
  2. Thanks, solved :D

    ReplyDelete
  3. Thank you very much. I've been sweating over this problem for last 2 days, this solved the problem. Roman

    ReplyDelete
  4. thanks, works very well! greetings from Brasil

    ReplyDelete
  5. Thanks for your informative blog!!! Your article helped me to understand the future of .net programming language. Keep on updating your with such awesome information. .net training | Dot net training

    ReplyDelete
  6. man! you really saved me! thanks =]

    ReplyDelete
  7. Thank you very much, you are life saver!

    ReplyDelete
  8. Excellent post!!! The future of .net application development is on positive note. It offers huge career prospects for talented professionals all over the world. Training on .net technology will ensure good salary package. Best DOT NET Training institute in Chennai | DOT NET Training Institutes in Chennai

    ReplyDelete
  9. works like a charm

    ReplyDelete
  10. WebMethods Training in Chennai
    This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic..

    ReplyDelete
  11. Thanks a Lot this has fixed the issue for EF6 and mysql .NetConnector 6.9.8

    ReplyDelete
  12. Hi I am getting the same problem for postgresql db. Any help would be appreciated.

    ReplyDelete
  13. Excellent read, Positive site, where did u come up with the information on this posting? I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work

    PSD to Wordpress
    wordpress website development

    ReplyDelete
  14. I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site.

    Best Java Training Institute Chennai

    Java Training Institute Bangalore

    ReplyDelete
  15. This comment has been removed by the author.

    ReplyDelete
  16. I have to voice my passion for your kindness giving support to those people that should have guidance on this important matter.
    Best Python Training Institute in Bangalore

    ReplyDelete
  17. Learn how to use Big Data Analytics from beginner level to advanced techniques which are taught by experienced working professionals.

    Hadoop Training in chennai

    ReplyDelete
  18. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.

    Amazon Web Services Training in Chennai

    Best Java Training Institute Chennai


    ReplyDelete
  19. I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site.
    rpa training in chennai

    ReplyDelete
  20. Awesome article. It is so detailed and well formatted that i enjoyed reading it as well as get some new information too.

    jira service desk training

    ReplyDelete
  21. Great post thanks for sharing for more update at
    Dot Net Online Course

    ReplyDelete
  22. Thanks a lot very much for the high quality and results-oriented help. I won’t think twice to endorse your blog post to anybody who wants and needs support about this area.
    java training in annanagar

    java training in chennai

    java training in marathahalli

    java training in btm layout

    java training in rajaji nagar

    java training in jayanagar

    ReplyDelete
  23. You’ve written a really great article here. Your writing style makes this material easy to understand.. I agree with some of the many points you have made. Thank you for this is real thought-provoking content
    MEAN stack training in Chennai
    MEAN stack training in bangalore
    MEAN stack training in tambaram
    MEAN stack training in annanagar
    MEAN stack training in Velachery
    MEAN stack training Sholinganallur

    ReplyDelete
  24. Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
    Devops Training in Chennai

    Devops Training in Bangalore

    Devops Training in pune

    Devops training in tambaram
    Devops training in velachery

    ReplyDelete
  25. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.

    rpa training in Chennai | rpa training in pune

    rpa training in tambaram | rpa training in sholinganallur

    rpa training in Chennai | rpa training in velachery

    rpa online training | rpa training in bangalore

    ReplyDelete
  26. Really great post, Thank you for sharing This knowledge.Excellently written article, if only all bloggers offered the same level of content as you, the internet would be a much better place. Please keep it up!
    python training institute in chennai
    python training in velachery
    python training institute in chennai

    ReplyDelete
  27. Excellant post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    java training in chennai | java training in bangalore

    java online training | java training in pune

    ReplyDelete
  28. Excellant post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    Python training in usa
    Python training in marathahalli
    Python training in pune

    ReplyDelete
  29. Really very nice blog information for this one and more technical skills are improve,i like that kind of post.
    DevOps online Training
    DevOps Training in USA

    ReplyDelete
  30. I love the blog. Great post. It is very true, people must learn how to learn before they can learn. lol i know it sounds funny but its very true. . .


    angularjs Training in bangalore

    angularjs Training in btm

    angularjs Training in electronic-city

    angularjs Training in online

    angularjs Training in marathahalli

    ReplyDelete
  31. Your new valuable key points imply much a person like me and extremely more to my office workers. With thanks from every one of us.

    Best AWS Training in Chennai | Amazon Web Services Training in Chennai

    AWS Training in Bangalore | Amazon Web Services Training in Bangalore

    Amazon Web Services Training in Pune | Best AWS Training in Pune


    Your new valuable key points imply much a person like me and extremely more to my office workers. With thanks from every one of us.

    ReplyDelete
  32. A universal message I suppose, not giving up is the formula for success I think. Some things take longer than others to accomplish, so people must understand that they should have their eyes on the goal, and that should keep them motivated to see it out til the end.

    Data Science course in kalyan nagar | Data Science course in OMR
    Data Science course in chennai | Data science course in velachery
    Data science online course | Data science course in jaya nagar

    ReplyDelete
  33. Excellent blog, I wish to share your post with my folks circle. It’s really helped me a lot, so keep sharing post like this
    Blueprism training in Pune

    Blueprism training in Chennai

    ReplyDelete
  34. myTectra Placement Portal is a Web based portal brings Potentials Employers and myTectra Candidates on a common platform for placement assistance

    ReplyDelete
    Replies

    1. I’m planning to start my blog soon, but I’m a little lost on everything. Would you suggest starting with a free platform like Word Press or go for a paid option? There are so many choices out there that I’m completely confused. Any suggestions? Thanks a lot.
      Best AWS Training in Marathahalli | AWS Training in Marathahalli
      Amazon Web Services Training in Anna Nagar, Chennai |Best AWS Training in Anna Nagar, Chennai

      Delete
  35. DevOps is currently a popular model currently organizations all over the world moving towards to it. Your post gave a clear idea about knowing the DevOps model and its importance.

    Good to learn about DevOps at this time.

    devops training in chennai | devops training in chennai with placement | devops training in chennai omr | devops training in velachery | devops training in chennai tambaram | devops institutes in chennai | devops certification in chennai

    ReplyDelete
  36. I and my friends were going through the nice, helpful tips from the blog then the sudden came up with an awful suspicion I never expressed respect to the website owner for those secrets.
    safety course in chennai

    ReplyDelete
  37. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as

    kajal agarwal hot

    ReplyDelete
  38. Amazing Article ! I have bookmarked this article page as i received good information from this. All the best for the upcoming articles. I will be waiting for your new articles. Thank You ! Kindly Visit Us @ Coimbatore Travels | Ooty Travels | Coimbatore Airport Taxi | Coimbatore taxi

    ReplyDelete
  39. This blog is the general information for the future. You got a good work for these blog.We have a developing our creative content of this mind.Thank you for this blog. This for very interesting and useful.

    Cloud Training in Chennai
    Software Testing Training in Chennai
    Oracle DBA Trainingin Chennai
    Angular Training in Chennai

    ReplyDelete
  40. This blog is full of Innovative ideas.surely i will look into this insight.please add more information's like this soon.
    AWS Training in Nolambur
    AWS Training in Perambur
    AWS Training in Ashok Nagar
    AWS Training in Nungambakkam

    ReplyDelete