Ent Lib 2.0 DAAB添加MySql扩展

2008-04-09 10:32:21　来源:中国自学编程网　作者:未知点击:

<configSections>
<section name="dataConfiguration"
      type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data
                , Version=2.0.0.0, Culture=neutral, PublicKeyToken=null" />
</configSections>
<dataConfiguration defaultDatabase="MySqlTest">
<providerMappings>
    <add databaseType="Microsoft.Practices.EnterpriseLibrary.Data.MySql.MySqlDatabase, Microsoft.Practices.EnterpriseLibrary.Data
               , Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"
      name="MySql.Data.MySqlClient" />
</providerMappings>
</dataConfiguration>
<connectionStrings>

<add name="MySqlTest" connectionString="Database=test;Data Source=localhost;User Id=root;Password=123;"
    providerName="MySql.Data.MySqlClient" />
</connectionStrings>
    为web项目添加Microsoft.Practices.EnterpriseLibrary.Data.dll的引用，web项目引用的命名空间：
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.MySql;
using MySql.Data.MySqlClient;
    部分测试代码如下：

private void displayBySqlText()
{
    Database database=DatabaseFactory.CreateDatabase("MySqlTest");
    string sql = "select * from test.tbluser where tbluser.UserCode like " +
        database.BuildParameterName("UserCode") + " and tbluser.UserName like " +
        database.BuildParameterName("UserName");
    DbCommand command = database.GetSqlStringCommand(sql);
    //database.AddParameter()方法会自动调用database.BuildParameterName()进行处理
    database.AddParameter(command, "UserCode", DbType.String, ParameterDirection.Input, "",
        DataRowVersion.Default, this.TextBox1.Text + "%");
    database.AddParameter(command, "UserName", DbType.String, ParameterDirection.Input, "",
        DataRowVersion.Default, "%" + this.TextBox2.Text + "%");
    DataSet ds = database.ExecuteDataSet(command);

    this.GridView1.DataSource = ds;
    this.GridView1.DataBind();
}
private void displayByProcedure()
{
    Database db = DatabaseFactory.CreateDatabase("MySqlTest");
    DataSet ds = db.ExecuteDataSet("SP_QueryUser"
        , new object[] { this.TextBox1.Text.Trim() + "%", "%" + this.TextBox2.Text.Trim() + "%" });