C#執行SQL指令碼

           
             string scriptDirectoryName = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), InstallerInfo.SCRIPTDIRECTORY);

//Scripts executing           

             ProcessStartInfo pi = new ProcessStartInfo("osql.exe");
            pi.WindowStyle = ProcessWindowStyle.Hidden;

            string osqlArgs = "-S " + System.Environment.MachineName + "\\" + InstallerInfo.MSDEINSTANCE +
                " -d master -U sa -P " + InstallerInfo.SAPWD + " -b -i ";

            foreach(string script in sequence)
            {
               
                    pi.Arguments = osqlArgs + "\"" + scriptDirectoryName + Path.DirectorySeparatorChar +
                                   "Queries" + Path.DirectorySeparatorChar + script + "\"" + " -o C:\\Temp\\" + script + ".log";
              

                Console.WriteLine(pi.Arguments);

                Process proc = Process.Start(pi);

                proc.WaitForExit();
               
            }