C#利用微软企业库Enterprise Library操作mysql数据库

<?xml version="1.0"?>
<configuration>
  <configSections>
    <section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings,Microsoft.Practices.EnterpriseLibrary.Data"/>
  </configSections>
  <system.data>
    <DbProviderFactories>
      <remove invariant="MySql.Data.MySqlClient"/>
      <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.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"/>
    </DbProviderFactories>
  </system.data>
  <connectionStrings>
    <clear/>
    <add name="mysql" connectionString="Database='test';Data Source='localhost';Port='3306';User Id='root';Password='';pooling=true" 
      providerName="MySql.Data.MySqlClient"/>
  </connectionStrings>
<startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/></startup>
</configuration>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Practices.EnterpriseLibrary.Data;
using System.Data;
using System.Data.Common;
namespace EnterpriseLibrary
{
    class SqlHelper
    {
       
        public static string  Add(string id,string name)
        {
            try
            {
                //建立连接
                Database db = DatabaseFactory.CreateDatabase("mysql");
                //数据插入指令
                DbCommand cmdAddOrder = db.GetSqlStringCommand(
@"insert into table1(id,name)values('" + id + "','" + name+"')");
              
                db.ExecuteNonQuery(cmdAddOrder);
                return "success";
            }
            catch (Exception ex)
            {
                //若操作时发生异常，则将异常信息写入到错误日志
                //LogContext.WriteError(ex);
                //Console.WriteLine("异常结果：{0}", ex);
                return ex.ToString();
            }
        }
       
        public static string Select(string id)
        {
            try
            {
                //创建一个连接
                Database db = DatabaseFactory.CreateDatabase("mysql");
                //创建一个插入command
                DbCommand cmd = db.GetSqlStringCommand("select id,name from table1 where id='" + id + "'");
                DataTable result = db.ExecuteDataSet(cmd).Tables[0];
                if (result.Rows.Count > 0)
                {
                   string str= result.Rows[0]["id"].ToString() +result.Rows[0]["name"].ToString();
                   return str;
                }
                else
                {
                    return "query fail";
                }
            }
            catch (Exception ex)
            {
                //若操作时发生异常，则将异常信息写入到错误日志
                // LogContext.WriteError(ex);
                return ex.ToString();
            }
        }
       
        public static string Update(string id,string name)
        {
            try
            {
                //创建一个连接
                Database db = DatabaseFactory.CreateDatabase("mysql");
                //创建一个插入command
                StringBuilder mysqlcommand = new StringBuilder();
                //生成SQL---Start
                mysqlcommand.Append("update table1 set name='").Append(name+"'");
                mysqlcommand.Append(" where id='").Append("2'");
                //生成SQL---End
                DbCommand cmdUpdataOrderState = db.GetSqlStringCommand(mysqlcommand.ToString());
                //执行SQL
                db.ExecuteNonQuery(cmdUpdataOrderState);
                return "Update Success";
            }
            catch (Exception ex)
            {
                //若操作时发生异常，则将异常信息写入到错误日志
                // LogContext.WriteError(ex);
                return ex.ToString();
            };
        }
     }
}