请教Enterprise Library 6.0怎样连接Mysql啊?
大家好:
第一次用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>