public void ForceDropConnections(string connectionString) { SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder(connectionString); RunHelpers run = new RunHelpers(); run.SyncProcess(String.Format("sqlcmd -S {0} -U {1} -P {2} -Q \"ALTER DATABASE {3} SET OFFLINE WITH ROLLBACK IMMEDIATE;\"", csb.DataSource, csb.UserID, csb.Password, csb.InitialCatalog)); run.SyncProcess(String.Format("sqlcmd -S {0} -U {1} -P {2} -Q \"ALTER DATABASE {3} SET ONLINE;\"", csb.DataSource, csb.UserID, csb.Password, csb.InitialCatalog)); }
public void DropDatabase(string connectionString) { SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder(connectionString); RunHelpers run = new RunHelpers(); run.SyncProcess(String.Format("sqlcmd -S {0} -U {1} -P {2} -Q \"DROP DATABASE {3};\"", csb.DataSource, csb.UserID, csb.Password, csb.InitialCatalog)); }
public void RunDeploymentProfile(string project, string publishProfile, string username, string password, string compilerPath = "c:\\Windows\\Microsoft.NET\\Framework\\v4.0.30319\\MSBuild.exe") { var path = GetSolutionDirectoryPath(); if (string.IsNullOrEmpty(path)) { throw new Exception("Could not find solution directory."); } var projectFilePath = GetProjectFilePath(path, project); RunHelpers run = new RunHelpers(); var command = string.Format("{0} {1} /p:DeployOnBuild=true /p:PublishProfile=\"{2}\" /p:AllowUntrustedCertificate=True /p:username={3} /p:password={4}", compilerPath, projectFilePath, publishProfile, username, password); run.SyncProcess(command); }