一,安装:
1、开发环境: VS2013与EF6
2、Mysql数据库为:Mysql Server 6.0
3、安装:Mysql for Visual Studio 1.1.1
4、安装 Mysql Connector/Net 6.8.3 GA
二,引用dll:
1、采用Nuget安装EF6.0.2;
2、采用Nuget安装MySql.Data.Entity.EF6
注意:要采用Nuget进行安装,否则可能会缺少相应的dll或者是配置信息
三、配置 web.config或app.config
1、将entitframework节点替代为:
1
2
3
4
5
6
7
|
<entityFramework codeConfigurationType= "MySql.Data.Entity.MySqlEFConfiguration, MySql.Data.Entity.EF6" > <defaultConnectionFactory type= "System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" /> <providers> <provider invariantName= "MySql.Data.MySqlClient" type= "MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" /> <provider invariantName= "System.Data.SqlClient" type= "System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" /> </providers> </entityFramework> |
2、添加 ConnectionString节点:
1
2
3
|
< connectionStrings > < add name = "MyContext" connectionString = "Data Source=localhost;port=3306;Initial Catalog=数据库名称;user id=Mysql的登录用户名;password=Mysql server密码;" providerName = "MySql.Data.MySqlClient" /> </ connectionStrings > |