// 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 { } }
// 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); } }