如何确保与数据库的连接不断开呢?

Question

不断开就行了啊，或者你把所有的条件想清楚、
如
SqlConnection conn = null;
        public SqlConnection GetConnection
        {
            get {
                if (conn == null)
                {
                    conn = new SqlConnection("server=.;uid=sa;pwd=sa;database=");
                    conn.Open();
                    
                }
                if (conn.State == ConnectionState.Broken)
                {
                    conn.Close();
                    conn.Open();
                }
                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }
            }
        }

Answer 1

注册一个链接事件，当链接断开时调用打开链接的方法，保持不断开链接