配置
前提
VS2013编译环境下务必安装mysql-connector-net-6.8.3(提取密码:gknf),引用MySql.Data.dll和 MySql.Data.MySqlClient.dll。
配置
主要配置四处,分别如下:
<appSettings> <!-- sqlserver\sqlce\mysql --> <add key="SqlProviderName" value="mysql"/> </appSettings>
<entityFramework> <!--sqlserver--> <!--<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"/>--> <!--mysql--> <defaultConnectionFactory type="MySql.Data.Entity.MySqlConnectionFactory, MySql.Data.Entity.EF6" /> <providers> <!--sqlserver--> <!--<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices,
EntityFramework.SqlServer"/>--> <!--mysql--> <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices,
MySql.Data.Entity.EF6"></provider> </providers> </entityFramework>
<connectionStrings> <!--sqlserver连接串--> <!--<add name="YunMFrameworkDbContext" connectionString="server=localhost;database=YunMFramework-Demo;
uid=sa;pwd=huawei123," providerName="System.Data.SqlClient" /> <add name="YunMFrameworkLog" providerName="System.Data.SqlClient" connectionString="server=.;database=YunMFrameworkLog;
uid=sa;pwd=huawei123,;" />--> <!--mysql连接串--> <add name="YunMFrameworkDbContext" connectionString="Data Source=localhost;database=YunMFramework-Demo;
User Id=root;Password=huawei123,;port=3306;" providerName="MySql.Data.MySqlClient"/> <add name="YunMFrameworkLog" connectionString="Data Source=.;database=YunMFrameworkLog-Demo;User Id=sa;
Password=huawei123,;port=3306;" providerName="MySql.Data.MySqlClient"/> </connectionStrings>