ASP.NET数据库连接池Data Connection Framework

数据库连接池Data Connection Framework具备Connection pooling机制，能管理不同的ADO.net Connection。并通过池对象工厂去PoolObjectFactory去创建数据连接池。(可参考：对象工厂创建--- Singleton Object,SingleCall Object,Pool Object )

 

连接池企业应用组件图如下：

 

 

 

类图如下：

 

 

 

 主要文件代码：

 

  /// <summary> /// 连接池上下文 /// </summary> public sealed class ConnectionPoolContext : IDisposable { /// <summary> /// 池对象工厂 /// </summary> private PoolObjectFactory _factory; /// <summary> /// 默认连接字符 /// </summary> private string _defaultConnectionString; /// <summary> /// 工厂名称 /// </summary> private string _factoryName; /// <summary> /// 类型 /// </summary> private Type _factoryType; /// <summary> /// SQL状态仓库 /// </summary> private SqlStatementRepository _statementRepository; /// <summary> /// 连接池 /// </summary> private static Dictionary<string, ConnectionPoolContext> _instances = new Dictionary<string, ConnectionPoolContext>(); /// <summary> /// 默认连接字符属性 /// </summary> public string DefaultConnectionString { get { return _defaultConnectionString; } set { _defaultConnectionString = value; } } /// <summary> /// 工厂名 /// </summary> public string FactoryName { get { return _factoryName; } set { _factoryName = value; } } /// <summary> /// SQL状态仓库属性 /// </summary> public SqlStatementRepository StatementRepository { get { if (_statementRepository == null) _statementRepository = new SqlStatementRepository(); return _statementRepository; } } /// <summary> /// 对象工厂模式 /// </summary> internal PoolObjectFactory Factory { get { return _factory; } set { _factory = value; } } /// <summary> /// 实例化一个连接池 /// </summary> /// <param name="id"></param> /// <returns></returns> public static ConnectionPoolContext Instance(string id) { return _instances[id]; } /// <summary> /// 添加一个连接到池中 /// </summary> /// <param name="id">id</param> /// <param name="factoryName">工厂名称</param> /// <param name="connectionString">连接字符串</param> /// <param name="max">最大数</param> /// <param name="limit">是否限制</param> public static void AddPool(string id, string factoryName, string connectionString, int max, bool limit) { ConnectionPoolContext p = new ConnectionPoolContext(); p._defaultConnectionString = connectionString; p._factoryName = factoryName; p.Factory = new PoolObjectFactory(max, limit, new ArrayList()); _instances.Add(id, p); } /// <summary> /// 得到一个连接 /// </summary> /// <returns>数据库连接</returns> public DbConnection AcquireConnection() { if (_factoryType == null) { DbProviderFactory dbFactory= DbProviderFactories.GetFactory(_factoryName); DbConnection conn = dbFactory.CreateConnection(); _factoryType = conn.GetType(); } DbConnection connection = (DbConnection)Factory.AcquireObject(_factoryType); if (connection.ConnectionString == string.Empty) connection.ConnectionString = _defaultConnectionString; return connection; } /// <summary> /// 释放一个连接 /// </summary> /// <param name="conn">数据库连接</param> public void ReleaseConnection(DbConnection conn) { Factory.ReleaseObject(conn); conn.Close(); } #region IDisposable Members /// <summary> /// 释放连接 /// </summary> public void Dispose() { if (_factory != null) ((IDisposable)_factory).Dispose(); } #endregion /// <summary> /// 私有构造函数 /// </summary> private ConnectionPoolContext() { } }