dapper.net for mysql



  <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