protected override void ProcessRecord() { if (base.ParameterSetName == PSName_ByComponent && !IntegratedSecurity.ToBool()) { if (string.IsNullOrEmpty(User)) { throw new ArgumentException("Parameter User is required"); } if (string.IsNullOrEmpty(Password)) { throw new ArgumentException("Parameter Password is required"); } } if (base.ParameterSetName == PSName_ByComponent) { WriteObject( new Albatross.Database.Database { DataSource = DataSource, InitialCatalog = InitialCatalog, SSPI = IntegratedSecurity.ToBool(), UserName = User, Password = Password, } ); } else { WriteObject(new Albatross.Database.Database { ConnectionString = ConnectionString, }); } }
public string GetConnectionString() { StringBuilder sb = new StringBuilder(); sb.Append($"data source={DataSource};"); sb.Append($"attachdbfilename={AttachDBFileName};"); sb.Append($"integrated security={IntegratedSecurity.ToPascalString()};"); sb.Append($"connect timeout={ConnectTimeout};"); sb.Append($"MultipleActiveResultSets={MultipleActiveResultSets.ToPascalString()};"); sb.Append($"App={App}"); return(sb.ToString()); }
public void SaveConfig() { var configFile = ConfigurationManager.OpenConfiguration(ConfigurationUserLevel.None); var settings = configFile.AppSettings.Settings; settings["InstanciaSQL"].Value = InstanciaSQL; settings["NomeDB"].Value = NomeBD; settings["Utilizador"].Value = Utilizador; settings["Password"].Value = Password; settings["DataSource"].Value = DataSource; settings["AttachDbFilename"].Value = AttachDbFilename; settings["IntegratedSecurity"].Value = IntegratedSecurity.ToString(); settings["ConnectTimeOut"].Value = ConnectTimeOut; configFile.Save(ConfigurationSaveMode.Modfied); ConfigurationManager.RefreshSection(configFile.AppSettings.Section.Information.Name); }
public string ToVisibleString() { string str = string.Format("Data Source={0};Network=DBMSSOCN;Initial Catalog={1};Integrated Security={2};UID={3};PWD=******;MultipleActiveResultSets={5};Application Name={6}", DataSource, InitialCatalog, IntegratedSecurity, UserID, Password, MultipleActiveResultsets, ApplicationName); if (IntegratedSecurity.ToUpper() == "TRUE") { str = string.Format("Data Source={0};Initial Catalog={1};Integrated Security={2};MultipleActiveResultSets={5};Application Name={6}", DataSource, InitialCatalog, IntegratedSecurity, UserID, Password, MultipleActiveResultsets, ApplicationName); } if (OtherAttributes != null) { foreach (string attr in OtherAttributes) { str += ";" + attr; } } return(str); }