<system.data>
<DbProviderFactories>
<remove invariant="MySql.Data.MySqlClient"/>
<add name="MySQL Data Provider2"
invariant="MySql.Data.MySqlClient"
description=".Net Framework Data Provider for MySQL"
type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.7.4, Culture=neutral, PublicKeyToken=2c7f6d112bbdac97" />
</DbProviderFactories>
</system.data>
using (IDbConnection conn = ConnectionFactory.SELECT)
{
string query =
@"SELECT xxxx
WHERE Status = 2";
return conn.Query<NotifyInterfaceSettingEntity>(query).ToList();
}
<add name="111" connectionString="" providerName="MySql.Data.MySqlClient" />
<add name="222" connectionString="" providerName="System.Data.SqlClient"/>
http://www.cnblogs.com/yankliu-vip/p/4182892.html