Microsoft.Practices.EnterpriseLibrary.Data Microsoft.Practices.EnterpriseLibrary.Common 使用-优快云博客

本文链接：https://blog.youkuaiyun.com/andycode/article/details/6741601

本文详细介绍了如何使用C#语言结合Enterprise Library框架实现数据库访问和SQL语句执行，包括获取DataSet和执行SQL命令。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;
        }
    }
}