Recently maintaining a Web site that intends to make some improvements using the Entity Framework for database operations.
The database of the website already has, but more than 100 tables, manual to write entity class some trouble, plan to use some ready-made tools to do.
Consider using EntityFramework Reverse POCO Code First Generator
Second, you can also use the entity Framework Power Tools,
https://visualstudiogallery.msdn.microsoft.com/72a60b14-1581-4b9b-89f2-846072eff19d/
After the installation is complete, right-click on your project name and select entity framework–> Reverse Engineering Code First in the pop-up menu.
Select the appropriate database connection
But in the actual operation, I can not find the MySQL database in the Change Data Source window, the local already installed mysql-connector-net-6.8.4. Through the online inquiry to know:
However, if you don't want the latest connector you have to download another product. From the Oracle website:
Starting with version 6.7, Connector/net would no longer include the MySQL for Visual Studio integration. That functionality was now available in a separate product called MySQL for Visual Studio available using the MySQL Install ER for Windows (see http://dev.mysql.com/tech-resources/articles/mysql-installer-for-windows.html).
Also need to go to MySQL's website to download the MySQL for Visual studio plugin
http://dev.mysql.com/downloads/windows/visualstudio/
Reverse-Generate entity classes based on existing MySQL database library