Dapper 随便点几下列表页就出数据库连接池问题了

悬赏园豆：5 [已关闭问题] 解决于 2017-09-17 19:55

项目使用的是.NET MVC5 + 三层 + Dapper 架构，下面我帖下关键代码：

BaseDAL:

public IDbConnection Conn
        {
            get
            {
                return CreateConnection();
            }
        }
        public static IDbConnection CreateConnection()
        {
            IDbConnection conn = null;
            switch (connectionName)
            {
                case "SQLServer":
                    conn = new SqlConnection(connStr);
                    break;
                default:
                    conn = new SqlConnection(connStr);
                    break;
            }
            conn.Open();
            return conn;
        }

分页列表代码：

public List<ContentModel> GetPageList(int pageSize, int pageIndex, out int rowCount, bool isAsc)
        {
            using (Conn)
            {
                string sortAsc;
                if (isAsc)
                {
                    sortAsc = "asc";
                }
                else
                {
                    sortAsc = "desc";
                }
                int start = (pageIndex - 1) * pageSize + 1;
                int end = pageIndex * pageSize;
                StringBuilder sql = new StringBuilder();
                sql.Append("select * from(select *, Row_Number() over(order by id " + sortAsc + ") as rowNumber from " + tb + ")t where t.rowNumber >= @start and t.rowNumber <= @end ");
                List<ContentModel> result = Conn.Query<ContentModel>(sql.ToString(), new { start = start, end = end }).ToList();
                rowCount = GetCount();
                return result;
            }
        }