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

27 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. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Android Training in Chennai
    Ios Training in Chennai

    ReplyDelete
  14. I wondered upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.

    Android App Development Company

    ReplyDelete
  15. I am expecting more interesting topics from you. And this was nice content and definitely it will be useful for many people.
    iOS App Development Company
    iOS App Development Company

    ReplyDelete
  16. I wondered upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.

    <Fitness SMS
    Fitness Text
    Salon SMS
    Salon Text
    Investor Relation SMS
    Investor Relation Text
    Mobile Marketing Services
    mobile marketing companies
    Sms API

    ReplyDelete
  17. great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
    web design Company
    web development Company
    web design Company in chennai
    web development Company in chennai
    web design Company in India
    web development Company in India

    ReplyDelete
  18. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Android Training in Chennai
    Ios Training in Chennai

    ReplyDelete