src/ZKEACMS/DbConnectionPool/TransientConnectionHolder.cs

（完整代码） 1KB 

/* http://www.zkea.net/ 
 * Copyright (c) ZKEASOFT. All rights reserved. 
 * http://www.zkea.net/licenses */

using System;
using System.Data.Common;

namespace ZKEACMS.DbConnectionPool
{

    public class TransientConnectionHolder : IDisposable, IConnectionHolder
    {
        private readonly IDbConnectionPool _pool;
        private readonly bool _objectShouldReturnToPool;

        public TransientConnectionHolder(IDbConnectionPool pool)
        {
            _pool = pool;
            DbConnection = _pool.ConnectionPool?.Get();
            if (DbConnection != null)
            {
                _objectShouldReturnToPool = true;
            }
            else
            {
                DbConnection = _pool.CreateDbConnection();
                _objectShouldReturnToPool = false;
            }
            if (DbConnection != null && DbConnection.State == System.Data.ConnectionState.Closed)
            {//预先打开数据库，为的是确保在使用EF的场合（比如ASP.Net）不会频繁打开/关闭数据库而致使性能下降
                DbConnection.Open();
            }
        }
        public DbConnection DbConnection { get; private set; }
        public void Dispose()
        {
            if (DbConnection != null)
            {
                if (_objectShouldReturnToPool)
                {
                    _pool.ConnectionPool.Return(DbConnection);
                }
                else
                {
                    DbConnection.Dispose();
                }

                DbConnection = null;
            }
        }
    }
}

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。