使用chole创建一个连接池

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131

using Chloe; using Chloe.Infrastructure; using Chloe.SqlServer; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks;   namespace Services {     /// <summary>     /// 数据库连接管理类     /// </summary>    public class DBconnectionManagement     {           public DBconnectionManagement() {             aconnList = new List<DbObject>();             aLock = new object();         }           private List<DbObject> aconnList { get; set; }             /// <summary>         /// 获去一个新的连接         /// </summary>         /// <returns></returns>         private MyDbContext getNewconn()         {             return new MyDbContext("data source=119.29.21.XXX;initial catalog=XXX;user id=XX;password=XXX");         }           /// <summary>         /// 新增一个连接到队列中         /// </summary>         private void Addconn() {             aconnList.Add(new DbObject(getNewconn()));             Console.WriteLine("新增了一个连接对象 目前" + aconnList.Count);         }           int getCount = 0;         object aLock { get; set; }         /// <summary>         /// 获取一个连接对象         /// </summary>         public IDbContext Getconn()         {             Console.WriteLine("获取一次 第"+ ++getCount);             IDbContext result;             lock (aLock)             {                 result = aconnList.Where(d => d.IsUse == false).Select(d => d.Conn).FirstOrDefault();             }             if (result == null)             {                 Addconn();                 return Getconn();             }             return result;         }     }     /// <summary>     /// 存放DB对象     /// </summary>     public class DbObject {         private DbObject() { }                   public DbObject(MyDbContext conn) {             conn.ABackOffFunc += BackOffFunc;             this.Conn = conn;             this.IsUse = false;         }         /// <summary>         /// 连接对象         /// </summary>         private MyDbContext conn { get; set; }           /// <summary>         /// 连接对象         /// </summary>         public MyDbContext Conn { get { IsUse = true;return conn;  } set { conn = value; } }           /// <summary>         /// 是否真正被使用         /// </summary>         public bool IsUse { get; set; }           /// <summary>         /// 销毁时候的回掉函数         /// </summary>         public Action<DbObject> AFuncComplete;             private void BackOffFunc(MyDbContext conn) {             AFuncComplete?.Invoke(this);             IsUse = false;         }       }     /// <summary>     /// 重写的连接对象     /// </summary>     public class MyDbContext : MsSqlContext, IDisposable {           public MyDbContext(string connString):base(connString) {           }         public MyDbContext(IDbConnectionFactory dbConnectionFactory) : base(dbConnectionFactory) {           }         public new void Dispose()         {             ABackOffFunc.Invoke(this);                      }         /// <summary>         /// 真实销毁函数         /// </summary>         public void Close() {             //如果不执行此操作将会一直保持连接  可以使用定时器销毁对象              base.Dispose();         }           /// <summary>         /// 销毁时候的回掉函数         /// </summary>         public Action<MyDbContext> ABackOffFunc;     } }