MariaDB10.04l使用EF5.0code first
工具:vs2012+MairaDB10.04+mysql-connector-net6.74
现在使用Nuget安装的EF版本是6.01;目前Mysql的.net驱动只支持5.0.(白搞了大半天,具体在哪看到的忘了,测试也是不支持6.0)
下面是配置文件
<configuration>
<configSections>
<!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
<system.web>
<compilation debug="true" targetFramework="4.5" />
<httpRuntime targetFramework="4.5" />
</system.web>
<system.data>
<!--没有这个会提示 找不到请求的 .Net Framework Data Provider。可能没有安装-->
<DbProviderFactories>
<add name="MySQL Data Provider" description="ADO.Net driver for MySQL" invariant="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data"/>
</DbProviderFactories>
</system.data>
<entityFramework>
<!--这里需要需要修改 默认的是sql--> <defaultConnectionFactory type=" MySql.Data.Entity.MySqlConnectionFactory, MySql.Data.Entity"> <parameters> <parameter value="v11.0" /> </parameters> </defaultConnectionFactory> </entityFramework> <connectionStrings> <add name="mysqlConn" connectionString="DataSource=localhost;DataBase=....;uid=root;pwd=...." providerName="MySql.Data.MySqlClient" /> </connectionStrings> </configuration>

浙公网安备 33010602011771号