Why Can't I Create an EDMX Entity Model with MySQL and EF6 in Visual Studio?

Troubleshoot Creation of Entity Data Model with MySQL and EF6

When attempting to add an EDMX Entity model to a C#/Web Project using MySQL and Entity Framework (EF6), it's possible to encounter issues where the model file is not created. This guide provides a comprehensive solution to resolve this problem.

Installation and Configuration

1. Remove any existing installations of "Connector/NET" and "MySQL for Visual Studio."
2. Install "MySQL for Visual Studio" v2.0.5 CTP.
3. Install "Connector/NET" v6.9.10.
4. Create a new Visual Studio project.
5. Install "EntityFramework" v6.2.0 via NuGet.

References and Configuration

6. Add references to "MySql.Data.dll" and "MySql.Data.Entity.EF6.dll" from the Connector/NET Assemblies folder.
7. Update the App.config file to include the MySQL EF6 provider information:

<entityFramework>
    <providers>
        <provider invariantName="MySql.Data.MySqlClient"
                  type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" />
    </providers>
</entityFramework>

8. Rebuild the project to ensure proper configuration.

Additional Notes

• Ensure that you follow the steps in the prescribed order.
• Refer to the provided references for detailed information on Connector versions and compatibility with Visual Studio IDEs.
• This solution has been successfully implemented in Visual Studio Professional 2017.

The above is the detailed content of Why Can't I Create an EDMX Entity Model with MySQL and EF6 in Visual Studio?. For more information, please follow other related articles on the PHP Chinese website!