public static void ApplyTimeoutChange(int newTimeout)
        {
            lock (_padlock)
            {
                CacheDataTableTimeoutSpec         tmSpec;
                IList <CachedDataTableIdentifier> removeList = new List <CachedDataTableIdentifier>();
                IList <CachedDataTableIdentifier> updateList = new List <CachedDataTableIdentifier>();
                foreach (CachedDataTableIdentifier id in _updateHist.Keys)
                {
                    if (newTimeout <= 0)
                    {
                        removeList.Add(id);
                    }
                    else
                    {
                        tmSpec = _updateHist[id];
                        TimeSpan ts = DateTime.Now.Subtract(tmSpec.RetrievedOn);
                        if (tmSpec.Timeout - ts.TotalSeconds > newTimeout)
                        {
                            removeList.Add(id);
                            updateList.Add(id);
                        }
                    }
                }

                foreach (CachedDataTableIdentifier id in removeList)
                {
                    if (_updateHist.ContainsKey(id))
                    {
                        _updateHist.Remove(id);
                    }

                    if (updateList.Contains(id))
                    {
                        CachedDataTableIdentifier newId = new CachedDataTableIdentifier();
                        newId.CopyFrom(id);
                        newId.Timeout      = newTimeout;
                        tmSpec             = new CacheDataTableTimeoutSpec();
                        tmSpec.RetrievedOn = DateTime.Now;
                        tmSpec.Timeout     = newTimeout;
                        _updateHist.Add(newId, tmSpec);
                    }
                }
            }
        }
        public static void StoreData(SqlConnection conn, CachedDataTableIdentifier id)
        {
            lock (_padlock)
            {
                if (id.DataType == CachedDataType.None)
                {
                    throw new Exception("CachedDataType is None!");
                }

                if (_cache.ContainsKey(id))
                {
                    DataTable rm = _cache[id];
                    _cache.Remove(id);
                    if (rm != null)
                    {
                        rm.Clear();
                        rm.Dispose();
                    }
                }

                if (_updateHist.ContainsKey(id))
                {
                    _updateHist.Remove(id);
                }

                string script = String.Empty;
                switch (id.DataType)
                {
                case CachedDataType.Databases:
                    script = ResManager.GetDBScript("Script_GetDatabases");
                    break;

                case CachedDataType.Users:
                    script = ResManager.GetDBScript("Script_GetUsers");
                    break;

                case CachedDataType.Objects:
                    script = ResManager.GetDBScript("Script_CodeCompletionProposalWithoutProcParams");
                    break;

                default:
                    break;
                }

                SqlCommand     cmd     = null;
                SqlDataAdapter adapter = null;
                DataTable      tbl     = null;

                try
                {
                    cmd = new SqlCommand(script, conn);
                    cmd.CommandTimeout    = 0;
                    adapter               = new SqlDataAdapter();
                    adapter.SelectCommand = cmd;
                    tbl = new DataTable();
                    adapter.Fill(tbl);
                }
                finally
                {
                    if (cmd != null)
                    {
                        cmd.Dispose();
                    }
                    if (adapter != null)
                    {
                        adapter.Dispose();
                    }
                }

                CachedDataTableIdentifier key = new CachedDataTableIdentifier();
                key.CopyFrom(id);
                if (key.Timeout > 0)
                {
                    CacheDataTableTimeoutSpec tmSpec = new CacheDataTableTimeoutSpec();
                    tmSpec.Timeout     = key.Timeout;
                    tmSpec.RetrievedOn = DateTime.Now;
                    _updateHist.Add(key, tmSpec);
                }
                _cache.Add(key, tbl);
            }
        }