As part of installing my application (WPF application), need to install SQL Server as well as a prerequisite. So when the user choose the option to install SQL Server, during the course of application installation, it need to get installed silently using the configuration.ini file provided with the setup.
So what i did was prepare a batch file called "InstallSQL.bat" through code which has the command to execute SQL server.
Now when the user choose to install SQL server, from installation code, the batch file is to be executed. The code is as below
ProcessInfo = new ProcessStartInfo(batchFilePath);
ProcessInfo.CreateNoWindow = true;
ProcessInfo.UseShellExecute = false;
ProcessInfo.WorkingDirectory = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
ProcessInfo.RedirectStandardError = true;
ProcessInfo.RedirectStandardOutput = true;
process = Process.Start(ProcessInfo);
MessageBox.Show("ExitCode: " + process.ExitCode);
When execute the setup, at the point of SQL Server installation, the SQL Server setup files are extracted and a console window opens up indicating installation is in progress.
The issue is, after some time in this console window a message appears saying "Process is terminated due to stackoverflowexception". Can someone please help me with an alternative for installing SQL Server silently (without user interaction).