public void StartPowershellScript() { MsSqlCreationParameters parameters = new MsSqlCreationParameters { PathToScript = @"C:\Users\Sven\Documents\local-git-repos\SqlBackup\SqlBackup\run_sqlexpress_docker.ps1", HttpLinkToDbMdfFile = "https://goo.gl/8CFlLQ", SuAdminPasswort = "XX5S4a5DpvDlWkY*zZl*", HostPort = "6999", PathToMdfFile = @"C:\Users\Sven\Documents\local-git-repos\SqlBackup\SqlBackup", NameOfDatabaseFile = "AdventureWorks2012_Data.mdf", DbName = "AdventureWorks2012_Data" }; MsSqlPowershellRunner psRunner = new MsSqlPowershellRunner(); psRunner.RunMsSqlExpressServer(parameters); }
public string RunMsSqlExpressServer(MsSqlCreationParameters parameters) { using (var powerShellScript = PowerShell.Create()) { powerShellScript.Commands.AddScript(parameters.ScriptContents); powerShellScript.Commands.AddArgument(parameters.HttpLinkToDbMdfFile); powerShellScript.Commands.AddArgument(parameters.NameOfDatabaseFile); powerShellScript.Commands.AddArgument(parameters.DoubleSlashPathToMdfFile); powerShellScript.Commands.AddArgument(parameters.PathToMdfFile); powerShellScript.Commands.AddArgument(parameters.SuAdminPasswort); powerShellScript.Commands.AddArgument(parameters.HostPort); powerShellScript.Commands.AddArgument(parameters.DbName); var output = powerShellScript.Invoke(); ContainerGuid = output.FirstOrDefault()?.ImmediateBaseObject as string; } return(ContainerGuid); }