Example #1
0
        /// <summary>
        /// 连接数据库
        /// </summary>
        /// <param name="connectionstring"></param>
        /// <remarks>连接同时将启动所有异步线程</remarks>
        public void Connect(string connectionstring = null)
        {
            if (connectionstring != null)
            {
                _ConnectionString = connectionstring;
            }

            if (Status == DataBaseStatus.Stoped)
            {
                //MessageBox.Show("数据库已停止");
                return;
            }
            if (Status == DataBaseStatus.Started)
            {
                //MessageBox.Show( "已经连接" );
                return;
            }

            Status = DataBaseStatus.Started;

            if (_ConnectionString == null)
            {
                //MessageBox.Show( "数据库未指定连接字符串" );
                return;
            }

            _Provider.Connect(_ConnectionString);
            _Provider.Connect(_ConnectionString);
        }
        internal DatabaseManager(String path = null, String databaseName = null)
        {
            String dbpath;
            if (databaseName == null)
            {
                dbpath = Path.Combine(path, DEFAULT_DATABASE_NAME);
            }
            else
                dbpath = Path.Combine(path, databaseName);

            // check file existence
            if (!File.Exists(dbpath))
            {
                // if not exist, then we create a new one
                SQLiteConnection.CreateFile(dbpath);
                _dbStatus = DataBaseStatus.NewDatabase;
            }
            else
            {
                _dbStatus = DataBaseStatus.DatabaseOK;
            }

            m_dbConnection = new SQLiteConnection();

            string connectionString = string.Format("Data Source={0};Version=3;MultipleActiveResultSets=true;", dbpath);

            m_dbConnection.ConnectionString = connectionString;

            if (_dbStatus == DataBaseStatus.NewDatabase)
            {
                InitDatabase();
            }
        }
Example #3
0
        internal DatabaseManager(String path = null, String databaseName = null)
        {
            String dbpath;

            if (databaseName == null)
            {
                dbpath = Path.Combine(path, DEFAULT_DATABASE_NAME);
            }
            else
            {
                dbpath = Path.Combine(path, databaseName);
            }

            // check file existence
            if (!File.Exists(dbpath))
            {
                // if not exist, then we create a new one
                SQLiteConnection.CreateFile(dbpath);
                _dbStatus = DataBaseStatus.NewDatabase;
            }
            else
            {
                _dbStatus = DataBaseStatus.DatabaseOK;
            }

            m_dbConnection = new SQLiteConnection();

            string connectionString = string.Format("Data Source={0};Version=3;MultipleActiveResultSets=true;", dbpath);

            m_dbConnection.ConnectionString = connectionString;

            if (_dbStatus == DataBaseStatus.NewDatabase)
            {
                InitDatabase();
            }
        }