/// <summary> /// Graba los datos /// </summary> protected override void Save() { if (ValidateData()) { // Asigna los datos al proyecto Connection.Name = Name; Connection.Description = Description; Connection.Type = (ConnectionModel.ConnectionType)(ComboTypes.SelectedId ?? 0); Connection.Parameters[nameof(Server)] = Server; Connection.Parameters[nameof(Port)] = Port.ToString(); Connection.Parameters[nameof(User)] = User; Connection.Parameters[nameof(Password)] = Password; Connection.Parameters[nameof(Database)] = Database; Connection.Parameters[nameof(UseIntegratedSecurity)] = UseIntegratedSecurity.ToString(); Connection.Parameters[nameof(MultipleActiveResultSets)] = MultipleActiveResultSets.ToString(); Connection.Parameters[nameof(ConnectionString)] = ConnectionString; Connection.Parameters[nameof(FileName)] = FileName; Connection.TimeoutExecuteScript = TimeSpan.FromMinutes(TimeoutExecuteScriptMinutes); // Añade la conexión a la solución si es necesario if (IsNew) { SolutionViewModel.Solution.Connections.Add(Connection); } // Graba la solución SolutionViewModel.SaveSolution(); // Actualiza el combo de conexiones SolutionViewModel.ConnectionExecutionViewModel.Load(); // Indica que ya no es nuevo y está grabado IsNew = false; IsUpdated = false; // Cierra la ventana RaiseEventClose(true); } }
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()); }