Vs+mysql+ef Configuration method

This time the project is using MySQL database, but the ADO Entity Data Model is not supported by default MySQL database, this document will explain how to make vs ADO. NET Entity Data model supports MySQL.

First, install the plug-in 1. VS Plugins

Mysql-for-visualstudio

: http://dev.mysql.com/downloads/windows/visualstudio/

2..NET Connection Program

Mysql-connector-net

: http://dev.mysql.com/downloads/connector/net/

By completing the above steps, you can map the MySQL database in VS, with the following effects:

　　

At this point, you can complete the local connection, but there is a problem with the remote connection. As follows:

　　

Second, set up MySQL remote connection 1. Modify the User table host field

Log in to MySQL by Root, find the MySQL database, find the user table

　　

Update the host field of the user table to change localhost to%.

　

2 Restart MySQL Service

Restart the MySQL service at this point, you can connect remotely

Effects such as:

　

Vs+mysql+ef Configuration method