- 下载Mysql for VisualStudiohttp://dev.mysql.com/downloads/windows/visualstudio/
- 下载连接器http://dev.mysql.com/downloads/connector/net/
- 使用Nuget安装EF。
- 使用Nuget安装Mysql.Data
- 修改web.config的connectionStrings连接字符串如下:
<connectionStrings>
<add name="DefaultConnection" connectionString="Data Source=服务器IP;port=3306;Initial Catalog=数据库名称;user id=用户名;password=密码;" providerName="MySql.Data.MySqlClient" />
</connectionStrings>
- 重要一定要在entityFramework节上增加codeConfigurationType="MySql.Data.Entity.MySqlEFConfiguration, MySql.Data.Entity.EF6"属性。
<entityFramework codeConfigurationType="MySql.Data.Entity.MySqlEFConfiguration, MySql.Data.Entity.EF6">
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
<parameters>
<parameter value="mssqllocaldb" />
</parameters>
</defaultConnectionFactory>
<providers>
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
<provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"></provider></providers>
</entityFramework>