예제 #1
0
        public clsDBUltity(bool blnCreateNew = false)
        {
            _blnCreateNew = blnCreateNew;

            if (!blnCreateNew)
            {
                _db = clsDBCore.getInstance();
            }
            else
            {
                _db = new clsDBCore(ConnectionString);
                _db.Open();
            }
        }
예제 #2
0
        public static void DisposeInstance()
        {
            if (_dbCore != null)
            {
                _dbCore.Close();
                _dbCore.Dispose();
                _dbCore = null;
            }

            //if (_cnn != null)
            //{
            //    _cnn.Dispose();
            //    _cnn = null;
            //}
        }
예제 #3
0
 public static clsDBCore getInstance(string connString = "")
 {
     if (_dbCore == null)
     {
         try
         {
             _dbCore = new clsDBCore(connString);
             _dbCore.Open();
         }
         catch (Exception ex)
         {
             Console.WriteLine("getInstance: " + ex.Message);
         }
     }
     return(_dbCore);
 }
예제 #4
0
        private bool disposedValue = false; // To detect redundant calls

        protected virtual void Dispose(bool disposing)
        {
            if (!disposedValue)
            {
                if (disposing)
                {
                    // TODO: dispose managed state (managed objects).
                    if (_db != null)
                    {
                        if (_blnCreateNew)
                        {
                            _db.Close();
                        }
                        _db.Dispose();
                        _db = null;
                    }
                }

                // TODO: free unmanaged resources (unmanaged objects) and override a finalizer below.
                // TODO: set large fields to null.

                disposedValue = true;
            }
        }