public ActionResult ConnectionString(ConnectionStringStepModel model) { if (!this.IsSetupState()) { return(this.Redirect("/")); } if (!this.ModelState.IsValid) { return(this.View(model)); } string connectionString = model.ConnectionString.Trim().TrimEnd(';') + "; Connection Timeout = 2"; try { SqlConnection connection = new SqlConnection(connectionString); connection.Open(); connection.Close(); } catch (Exception e) { this.ModelState.AddModelError("ConnectionString", e.Message); return(this.View(model)); } Configuration configuration = WebConfigurationManager.OpenWebConfiguration("~"); ConnectionStringsSection section = (ConnectionStringsSection)configuration.GetSection("connectionStrings"); section.ConnectionStrings["AspNetDeployEntities"].ConnectionString = ConfigurationManager.ConnectionStrings["AspNetDeployEntitiesTemplate"].ConnectionString.Replace("{connectionString}", model.ConnectionString.Trim().TrimEnd(';')); section.ConnectionStrings["AspNetDeployEntitiesClean"].ConnectionString = model.ConnectionString.Trim(); configuration.Save(); return(this.RedirectToAction("DatabaseStructure")); }
public ActionResult ConnectionString() { if (!this.IsSetupState()) { return(this.Redirect("/")); } ConnectionStringStepModel model = new ConnectionStringStepModel() { ConnectionString = ConfigurationManager.ConnectionStrings["AspNetDeployEntitiesClean"].ConnectionString }; Configuration configuration = WebConfigurationManager.OpenWebConfiguration("~"); configuration.AppSettings.Settings["Settings.SetupState"].Value = "ConnectionString"; configuration.Save(); return(this.View(model)); }