示例#1
0
        /// <summary>
        /// 关闭连接,返回连接池
        /// </summary>
        /// <param name="dbw"></param>
        public void ReleaseConn(DbConnectionWrapper dbw)
        {
            if (dbw == null)
            {
                return;
            }

            lock (this._lockObject)
            {
                if (this._dbUsed.Contains(dbw))
                {
                    this._dbUsed.Remove(dbw);
                    //如果连接已经不能用,则释放掉
                    if (dbw.CanUse())
                    {
                        this._dbCanUse.Add(dbw);
                    }
                    else
                    {
                        try
                        {
                            dbw.Conn?.Close();
                        }
                        catch { }
                    }
                }
                else
                {
                    this._dbCanUse.Add(dbw);
                }
            }
        }
示例#2
0
        private int _checkConnTimeout = 60;  //60s


        /// <summary>
        /// 使用连接信息构造一个数据库连接管理类
        /// </summary>
        /// <param name="connInfo"></param>
        /// <param name="initConn">初始连接:5,建议和最小池子数一致</param>
        /// <param name="timeout">30s</param>
        public DbConnectionManager(DbConnOption connInfo, int initConn = 5, int timeout = 30)
        {
            this._initConn = initConn;
            this._connInfo = new DbConnOption(connInfo.DbConnectionString, connInfo.DbConnectionType);
            if (initConn > 0)
            {
                DbConnectionWrapper[] arrConn = new DbConnectionWrapper[initConn];
                Parallel.For(0, initConn, x =>
                {
                    arrConn[x] = this.CreateNew();
                });
                this._dbCanUse.AddRange(arrConn.Where(x => x != null));
            }

            //开启线程,定时检查释放多余的连接
            Thread th = new Thread(CheckConn)
            {
                IsBackground = true,
                Priority     = ThreadPriority.BelowNormal,
                Name         = "检查数据库连接"
            };

            th.Start(this);
        }