Microsoft.Practices.EnterpriseLibrary.Data Microsoft.Practices.EnterpriseLibrary.Common 使用

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Common;
using System.Data;
using System.Windows.Forms;

namespace DBAccess
{
    class DBAccess : IDBAccess
    {
        //根据传入的SQL语句返回一个DataSet
        public DataSet GetDataSet(string sql)
        {
            DataSet productsDataSet = null;
            
            try
            {
                Database db = DatabaseFactory.CreateDatabase();

                DbCommand dbCommand = db.GetSqlStringCommand(sql);

                productsDataSet = db.ExecuteDataSet(dbCommand);
                
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            return productsDataSet;
        }

        //根据传入的SQL语句返回一个整数结果
        public int ExecuteSQL(string sql)
        {
            int i = 0;
            try
            {
                Database db = DatabaseFactory.CreateDatabase();

                DbCommand dbCommand = db.GetSqlStringCommand(sql);

                i = dbCommand.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            return i;
        }
    }
}