Пример #1
0
        // Registry: read all
        internal void ReadConnections()
        {
            try
            {
                _connBuilders.Clear();

                // open registry subkey
                var key = Registry.CurrentUser.OpenSubKey(REGISTRY_CONNSTRINGS);

                // create Registry subkey
                if (key != null && key.ValueCount > 0)
                {
                    // read registry values
                    foreach (var name in key.GetValueNames())
                    {
                        var value = key.GetValue(name);
                        if (value != null && value is System.String && !String.IsNullOrWhiteSpace((string)value))
                        {
                            try
                            {
                                var connString = ConnectionEncryption.DecryptAes((string)value);
                                _connBuilders.Add(new SqlConnectionStringBuilder(connString));
                            }
                            // catch exception if value is not a conn string
                            catch { }
                        }
                    }
                }
                else
                {
                    Registry.CurrentUser.CreateSubKey(REGISTRY_CONNSTRINGS);
                }
            }
            catch { }
        }
Пример #2
0
        // read QueryTalkBase connection
        internal SqlConnectionStringBuilder GetQueryTalkBaseConnection()
        {
            try
            {
                var root = ProvideRoot();

                // check
                if (root == null)
                {
                    return(null);   // not likely to happen
                }

                var queryTalkBaseConnection = (string)root.GetValue(REGISTRY_QueryTalkBaseConnection);
                var connString = ConnectionEncryption.DecryptAes(queryTalkBaseConnection);

                if (!string.IsNullOrEmpty(connString))
                {
                    return(new SqlConnectionStringBuilder(connString));
                }

                return(null);
            }
            catch
            {
                return(null);
            }
        }