数据库打开关闭操作

刚刚接触.net记录些东西慢慢学习，呵呵

记录些打开关闭的操作，希望浏览过的人有好的方法也提供下

 

 

public class DataBase:IDisposable 
    {
        protected SqlConnection Connection;  //数据库连接对象

        protected string ConnectionString;   //连接字符串变量


        /// <summary>
        /// 构造函数，获取连接字符
        /// </summary>
        public DataBase()
        {
            ConnectionString = "";
        }


        #region 数据库打开与关闭
        /// <summary>
        /// 打开连接
        /// </summary>
        protected void Open()
        {
            if (Connection == null)
            {
                Connection = new SqlConnection(ConnectionString);
            }
            if(Connection.State.Equals(ConnectionState.Open()))
            {
                Connection.Open();
            }
        }

        /// <summary>
        /// 关闭数据库连接
        /// </summary>
        public void Close()
        {
            if (Connection != null)
            {
                Connection.Close();
                Dispose();
            }
        }

        /// <summary>
        /// 释放资源
        /// </summary>
        public void Dispose()
        {
            if (Connection != null)
            {
                Dispose();
                Connection = null;
            }
        }
    }