请教Enterprise Library 6.0怎样连接Mysql啊?

likeyrain likeyrain 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
大家好:
第一次用Enterprise Library 6.0去连接Mysql,弄了好久都没试成功,想请教一下各位。

有下面的一断配置,但总是报错:The connection string for the default database 'mysql' does not exist or does not have a valid provider.

<configSections>
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="true" />
</configSections>
<dataConfiguration defaultDatabase="mysql" />
<connectionStrings>
<add name="MysqlServer" connectionString="Server=192.168.29.21;Port=3306;Option=131072;Stmt=;Database=psms; User=root;Password=123456;"
providerName="MySql.Data.MySqlClient" />
<add name="mysql1" connectionString="Data Source=192.168.29.21;Initial Catalog=psms;User ID=root;Password=123456"
providerName="MySql.Data.MySqlClient" />
<add name="mysql" connectionString="Server=192.168.29.21;Port=3306;Database=psms;Uid=root;Pwd=123456;"
providerName="MySql.Data.MySqlClient" />
</connectionStrings>
<appSettings>
<add key="aspnet:UseTaskFriendlySynchronizationContext" value="true" />
</appSettings>
<system.data>
<DbProviderFactories>
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
<remove invariant="MySql.Data.MySqlClient" />
</DbProviderFactories>
</system.data>
<system.web>
<compilation debug="true" targetFramework="4.5.2" />
<httpRuntime targetFramework="4.5.2" />
</system.web>
<system.serviceModel>
...全文

相关推荐

评论 7
收藏 已收藏
分享
返回顶部
likeyrain
.NET Framework 17,748 成员 24,324 内容