Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public ConnectionStringList ConnectionStrings(string Path_Config)
- {
- var result = new List<string>();
- var MyConnectionList = new ConnectionStringList();
- MyConnectionList.OrcaReorcaConnectionsList = new List<string>();
- MyConnectionList.OrcaConnectionsList = new List<string>();
- MyConnectionList.ReorcaConnectionsList = new List<string>();
- ExeConfigurationFileMap configOld = new ExeConfigurationFileMap();
- configOld.ExeConfigFilename = Path_Config;
- Configuration config = ConfigurationManager.OpenMappedExeConfiguration(configOld, ConfigurationUserLevel.None);
- string GetPrefixes = config.AppSettings.Settings["Prefix"].Value;
- var Prefixes = GetPrefixes.Split(';');
- foreach (var Prefix in Prefixes)
- {
- var ToAdd = from x in config.AppSettings.Settings.AllKeys
- where x.ToLower() == Prefix + "oraconnectionstring"
- select config.AppSettings.Settings[x].Value;
- // result.Add(ToAdd);
- //foreach (var item in config.AppSettings.Settings.AllKeys)
- //{
- // //if (item.ToLower().StartsWith(Prefix) && item.ToLower().EndsWith("oraconnectionstring"))
- // //if (item.ToLower() == Prefix.ToLower() + "oraconnectionstring")
- // //{
- // // result.Add(config.AppSettings.Settings[item.ToString()].Value);
- // // break;
- // //}
- //}
- }
- //List<string> result = new List<string>(
- // from x in config.AppSettings.Settings.AllKeys
- // where x.ToLower().StartsWith("or") && x.ToLower().EndsWith("connectionstring")
- // select config.AppSettings.Settings[x].Value);
- foreach (var ConnectionString in result)
- {
- MyConnectionList.OrcaReorcaConnectionsList.Add(ConnectionString);
- var SplitConnection = ConnectionString.Split(';');
- var GetUserID = SplitConnection[0].Substring(SplitConnection[0].IndexOf("=") + 1/*, SplitConnection[0].Length*/);
- if (GetUserID.ToLower().StartsWith("orca")) MyConnectionList.OrcaConnectionsList.Add(ConnectionString);
- else if (GetUserID.ToLower().StartsWith("reorca")) MyConnectionList.ReorcaConnectionsList.Add(ConnectionString);
- }
- return MyConnectionList;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement