Enable Entity Framework 6 for MySql (C#) in WinForms of Microsoft Visual Studio 2013

by

First of all, we don’t even need to install the mysql-installer-community-5.7.3.0-m13.msi.

  1. Install the latest mysql-visualstudio-plugin
  2. Install the latest mysql-connector-net
  3. New C# .Net 4.5 Framework WinForms (for 4.0 it should work based on Does Entity Framework 6 support .NET 4.0? )
  4. Install 4 Nuget Packages (follow sequence, if you install Mysql.Data.Entities before EntityFramework, it will resolve dependency and install EntityFramework 6.0.2 but what we need is EntityFramework 6.1.0)

EntityFramework

Mysql.Data

Mysql.Data.Entities

Mysql.Web

5.If you have tag entityFramework in App.config, please comment it and insert new tag entityFramework in App.config after tag startup

  <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>

6.Add ADO.NET Entity Data Model (as mentioned in question)

7.After Entity Connection string is generated (as mentioned in question) and Tick Save entity connection settings in App.Config as then click Next

8.Choose Your Database Object and Settings (Tables, Views, or Stored Procedures and Functions) (Don’t have “Which version of Entity Framework do you want to use?” because I have only one Entity Framework 6.0 provider so direct skip the selection if my only provider is valid)

9.Finish

Congratulations ^^

By the way, you may need to add the .dll files

  • MySql.Data.dll
  • MySql.Data.Entity.EF6.dll
  • MySql.Web.dll

inside this folder

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)

as your project reference for further EF6 functions.

More Related Contents:

  1. Dynamic MySQL database connection for Entity Framework 6
  2. Why do I get “System.Data.DataRowView” instead of real values in my WinForms Listbox?
  3. C#, Winform: How to pass information from one form to another [duplicate]
  4. How do I suspend painting for a control and its children?
  5. How to use the Paint event to draw shapes at mouse coordinates
  6. Properly draw text using GraphicsPath
  7. How to stop BackgroundWorker correctly
  8. Convert json to a C# array?
  9. How do I automatically scroll to the bottom of a multiline text box?
  10. EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship
  11. How can I bring my application window to the front? [duplicate]
  12. Cannot close Excel.exe after Interop process
  13. How do you prevent a windows from being moved?
  14. How to force C# .net app to run only one instance in Windows? [duplicate]
  15. A textbox/richtextbox that has syntax highlighting? [C#] [closed]
  16. How to create custom PropertyGrid editor item which opens a form?
  17. Open link in new TAB (WebBrowser Control)
  18. How to create a C# Winforms Control that hovers
  19. How to read another windows from a different program
  20. ‘Forms’ does not exist in the namespace system.windows
  21. Hosting ASP.NET Core API in a Windows Forms Application
  22. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  23. How to make a button appear as if it is pressed?
  24. Only allow specific characters in textbox
  25. ComboBox draw image on selected item
  26. Read nodes of a xml file in C#
  27. How to use String property as primary key in Entity Framework
  28. How to use dependency injection in WinForms
  29. Saving content of a treeview to a file and load it later
  30. How to create a Button that can send keys to a control without stealing the focus – Virtual Keyboard

Leave a Comment