I'm trying to add an edmx Entity model to my C#/Web Project in Visual Studio 2013. My problem is that the file is not created.
I do the following steps:
No edmx file is created. (although it works with SQL Server, but not for MySQL)
Entity Framework 6.1.2 installed,
MySql.Web -- all installed.
I also rebuilt the project before trying to add an entity model file.
I've installed the latest MySQL package with the latest
Running: Visual Studio 2013 on Windows 7.
Any ideas how to solve this?
I solved this issue by following some steps below:
MySql.Data.Entities from Nuget by using command below in Package Manager Console:
Add project reference to the latest
MySql.Data.Entity.EF6.dll from your MySql connector installation path at:
C:\Program Files (x86)\MySQL\MySQL Connector Net 6.9.8\Assemblies\v4.5
I just had the same situation when trying to configure Visual Studio Professional 2017 environment with MySQL, ADO.NET (Database First) and EF6.
Note: Please follow steps in the same order.
Uninstall/remove "Connector/NET" and "MySQL for Visual Studio" if installed.
Install "MySQL for Visual Studio" v2.0.5 CTP (MySQL for Visual Studio). Note: Install MySQL for Visual Studio before Connector/NET.
Install "Connector/NET" v6.9.10 (Connector/Net). https://i.stack.imgur.com/XOT1I.jpg Note: I tried using Connector/NET v6.8, v6.10 and v8 first, but none of them worked with Visual Studio 2017 and ADO.Net. Here you can find all Connector Versions and Compatibilities with Visual Studio IDEs, but so far this list is inaccurate.
Create new Visual Studio Professional 2017 project.
Download and Install "EntityFramework" v6.2.0 through NuGet, by going to Project Tab/Manage NuGet Packages/Browse -> Entity Framework.
Add references to
C:\Program Files (x86)\MySQL\Connector.NET 6.9.10\Assemblies\v4.5\MySql.Data.dll
C:\Program Files (x86)\MySQL\Connector.NET 6.9.10\Assemblies\v4.5\MySql.Data.Entity.EF6.dll; by Right Clicking over References inside Solution Explorer and selecting Add Reference/Browse ->Browse button.
Add MySQL EF6 provider info inside App.config under entity framework providers as follow:
<entityFramework> <providers> <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" /> </providers> </entityFramework>
And that's it. VS2017 is ready to go. Hope this works for everybody, as it did for me today.