企业库连接形式简单例子记录 EnterpriseLibrary.Data-CSDN博客

结构图

webconfig 配置正确的连接字符串

<connectionStrings>
    <add name="DBConnection" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True"
　　providerName="System.Data.SqlClient" />
  </connectionStrings>

创建数据库连接

namespace RedisDemo.Component.DataAccess
{
    public class TestData
    {
        public static Database TestConnection
        {
            get
            {
                //EnterpriseLibrary.Data v5.0
                //return DatabaseFactory.CreateDatabase("DBConnection");

                //EnterpriseLibrary.Data v6.0
                DatabaseProviderFactory factory = new DatabaseProviderFactory();
                return factory.Create("DBConnection");
            }
        }
    }
}

使用DLL

namespace RedisDemo.Component.DLL
{
    public class UserDAL
    {
        private Database _db = TestData.TestConnection;

        public List<UserInfo> GetUserList()
        {
            var sql = "select * from Users";
            DbCommand command = _db.GetSqlStringCommand(sql);
            List<UserInfo> list = new List<UserInfo>();
            using (IDataReader dr = _db.ExecuteReader(command))
            {
                while (dr.Read())
                {
                    UserInfo user = new UserInfo();
                    user.ID = int.Parse(dr["ID"].ToString());
                    user.Name = dr["Name"].ToString();
                    list.Add(user);
                }
            }
            return list;
        }
    }
}

BLL

namespace RedisDemo.Component.BLL
{
    public class UserBLL
    {
        private UserDAL _dal = new UserDAL();
        private static UserBLL _instance;

        public static UserBLL Instance
        {
            get { return (_instance ?? new UserBLL()); }
        }

        private UserBLL() { }

        public List<UserInfo> GetUserList()
        {
            return _dal.GetUserList();
        }
    }
}