blocks|key|1604167|text|将执行sql脚本的命令放入批处理文件中，然后运行以下代码|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1604168|string+batchFileName+=+@"c:\batosql.bat";
string+sqlFileName+=+@"c:\MySqlScripts.sql";
Process+proc+=+new+Process();
proc.StartInfo.FileName+=+batchFileName;
proc.StartInfo.Arguments+=+sqlFileName;
proc.StartInfo.WindowStyle+=+ProcessWindowStyle.Hidden;
proc.StartInfo.ErrorDialog+=+false;
proc.StartInfo.WorkingDirectory+=+Path.GetDirectoryName(batchFileName);
proc.Start();
proc.WaitForExit();
if+(+proc.ExitCode!=+0+)|code-block|syntax|javascript|1604169|在批处理文件中，编写如下内容(+sql+server示例)|1604170|osql+-E+-i+%251|1604171|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Put the command to execute the sql script into a batch file then run the below code

<pre><code>string batchFileName = @"c:\batosql.bat";
string sqlFileName = @"c:\MySqlScripts.sql";
Process proc = new Process();
proc.StartInfo.FileName = batchFileName;
proc.StartInfo.Arguments = sqlFileName;
proc.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
proc.StartInfo.ErrorDialog = false;
proc.StartInfo.WorkingDirectory = Path.GetDirectoryName(batchFileName);
proc.Start();
proc.WaitForExit();
if ( proc.ExitCode!= 0 )
</code></pre>

in the batch file write something like this (sample for sql server)

<pre><code>osql -E -i %1
</code></pre>

blocks|key|1389273|text|using+System;
using+System.Collections.Generic;
using+System.Linq;
using+System.Web;
using+System.Web.UI;
using+System.Web.UI.WebControls;
using+Microsoft.SqlServer.Management.Smo;
using+Microsoft.SqlServer.Management.Common;
using+System.IO;
using+System.Data.SqlClient;

public+partial+class+ExcuteScript+:+System.Web.UI.Page
{
++++protected+void+Page_Load(object+sender,+EventArgs+e)
++++{
++++++++string+sqlConnectionString+=+@"Integrated+Security=SSPI;Persist+Security+Info=False;Initial+Catalog=ccwebgrity;Data+Source=SURAJIT\SQLEXPRESS";

++++++++string+script+=+File.ReadAllText(@"E:\Project+Docs\MX462-PD\MX756_ModMappings1.sql");

++++++++SqlConnection+conn+=+new+SqlConnection(sqlConnectionString);

++++++++Server+server+=+new+Server(new+ServerConnection(conn));

++++++++server.ConnectionContext.ExecuteNonQuery(script);
++++}
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1389274|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;
using System.IO;
using System.Data.SqlClient;

public partial class ExcuteScript : System.Web.UI.Page
{
 protected void Page_Load(object sender, EventArgs e)
 {
 string sqlConnectionString = @&quot;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ccwebgrity;Data Source=SURAJIT\SQLEXPRESS&quot;;

 string script = File.ReadAllText(@&quot;E:\Project Docs\MX462-PD\MX756_ModMappings1.sql&quot;);

 SqlConnection conn = new SqlConnection(sqlConnectionString);

 Server server = new Server(new ServerConnection(conn));

 server.ConnectionContext.ExecuteNonQuery(script);
 }
}
</code></pre>

blocks|key|1604260|text|我用Microsoft.SqlServer.Management尝试了这个解决方案，但它在.NET+4.0上不能很好地工作，所以我只用.NET+libs框架写了另一个解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1604261|string+script+=+File.ReadAllText(@"E:\someSqlScript.sql");

//+split+script+on+GO+command
IEnumerable<string>+commandStrings+=+Regex.Split(script,+@"%5E\s*GO\s*$",+RegexOptions.Multiline+%7C+RegexOptions.IgnoreCase);

Connection.Open();
foreach+(string+commandString+in+commandStrings)
{
++++if+(!string.IsNullOrWhiteSpace(commandString.Trim()))
++++{
++++++++using(var+command+=+new+SqlCommand(commandString,+Connection))
++++++++{
++++++++++++command.ExecuteNonQuery();
++++++++}
++++}
}+++++
Connection.Close();|code-block|syntax|javascript|1604262|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I tried this solution with Microsoft.SqlServer.Management but it didn't work well with .NET 4.0 so I wrote another solution using .NET libs framework only.

<pre><code>string script = File.ReadAllText(@"E:\someSqlScript.sql");

// split script on GO command
IEnumerable&lt;string&gt; commandStrings = Regex.Split(script, @"^\s*GO\s*$", RegexOptions.Multiline | RegexOptions.IgnoreCase);

Connection.Open();
foreach (string commandString in commandStrings)
{
 if (!string.IsNullOrWhiteSpace(commandString.Trim()))
 {
 using(var command = new SqlCommand(commandString, Connection))
 {
 command.ExecuteNonQuery();
 }
 }
} 
Connection.Close();
</code></pre>

blocks|key|1389380|text|有两点需要考虑。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1389381|1)此源码适用于我：|1389382|private+static+string+Execute(string+credentials,+string+scriptDir,+string+scriptFilename)
{+
++Process+process+=+new+Process();
++process.StartInfo.UseShellExecute+=+false;
++process.StartInfo.WorkingDirectory+=+scriptDir;
++process.StartInfo.RedirectStandardOutput+=+true;
++process.StartInfo.FileName+=+"sqlplus";
++process.StartInfo.Arguments+=+string.Format("{0}+@{1}",+credentials,+scriptFilename);
++process.StartInfo.CreateNoWindow+=+true;

++process.Start();
++string+output+=+process.StandardOutput.ReadToEnd();
++process.WaitForExit();

++return+output;
}|code-block|syntax|javascript|1389383|我将工作目录设置为脚本目录，这样脚本中的子脚本也可以工作。|1389384|将其命名为Execute("usr/pwd@service",+"c:\myscripts",+"script.sql")|offset|length|style|CODE|1389385|2)您必须使用语句EXIT;完成SQL脚本。|1389386|entityMap^0|0|0|0|0|5|1K|0|9|5|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|Y|8|@$M|Z|N|10|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|11|8|@$M|12|N|13|O|P]]|9|@]|A|$]]|$1|S|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|T|$]]

There are two points to considerate.

1) This source code worked for me:

<pre><code>private static string Execute(string credentials, string scriptDir, string scriptFilename)
{ 
 Process process = new Process();
 process.StartInfo.UseShellExecute = false;
 process.StartInfo.WorkingDirectory = scriptDir;
 process.StartInfo.RedirectStandardOutput = true;
 process.StartInfo.FileName = "sqlplus";
 process.StartInfo.Arguments = string.Format("{0} @{1}", credentials, scriptFilename);
 process.StartInfo.CreateNoWindow = true;

 process.Start();
 string output = process.StandardOutput.ReadToEnd();
 process.WaitForExit();

 return output;
}
</code></pre>

I set the working directory to the script directory, so that sub scripts within the script also work.

Call it e.g. as <code>Execute("usr/pwd@service", "c:\myscripts", "script.sql")</code>

2) You have to finalize your SQL script with the statement <code>EXIT;</code>

blocks|key|1604324|text|这对我来说很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1604325|public+void+updatedatabase()
{

++++SqlConnection+conn+=+new+SqlConnection("Data+Source="+%2B+txtserver.Text.Trim()+%2B+";Initial+Catalog="+%2B+txtdatabase.Text.Trim()+%2B+";User+ID="+%2B+txtuserid.Text.Trim()+%2B+";Password="+%2B+txtpwd.Text.Trim()+%2B+"");
++++try
++++{

++++++++conn.Open();

++++++++string+script+=+File.ReadAllText(Server.MapPath("~/Script/DatingDemo.sql"));

++++++++//+split+script+on+GO+command
++++++++IEnumerable<string>+commandStrings+=+Regex.Split(script,+@"%5E\s*GO\s*$",+RegexOptions.Multiline+%7C+RegexOptions.IgnoreCase);
++++++++foreach+(string+commandString+in+commandStrings)
++++++++{
++++++++++++if+(commandString.Trim()+!=+"")
++++++++++++{
++++++++++++++++new+SqlCommand(commandString,+conn).ExecuteNonQuery();
++++++++++++}
++++++++}
++++++++lblmsg.Text+=+"Database+updated+successfully.";

++++}
++++catch+(SqlException+er)
++++{
++++++++lblmsg.Text+=+er.Message;
++++++++lblmsg.ForeColor+=+Color.Red;
++++}
++++finally
++++{
++++++++conn.Close();
++++}
}|code-block|syntax|javascript|1604326|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This works for me: 

<pre><code>public void updatedatabase()
{

 SqlConnection conn = new SqlConnection("Data Source=" + txtserver.Text.Trim() + ";Initial Catalog=" + txtdatabase.Text.Trim() + ";User ID=" + txtuserid.Text.Trim() + ";Password=" + txtpwd.Text.Trim() + "");
 try
 {

 conn.Open();

 string script = File.ReadAllText(Server.MapPath("~/Script/DatingDemo.sql"));

 // split script on GO command
 IEnumerable&lt;string&gt; commandStrings = Regex.Split(script, @"^\s*GO\s*$", RegexOptions.Multiline | RegexOptions.IgnoreCase);
 foreach (string commandString in commandStrings)
 {
 if (commandString.Trim() != "")
 {
 new SqlCommand(commandString, conn).ExecuteNonQuery();
 }
 }
 lblmsg.Text = "Database updated successfully.";

 }
 catch (SqlException er)
 {
 lblmsg.Text = er.Message;
 lblmsg.ForeColor = Color.Red;
 }
 finally
 {
 conn.Close();
 }
}
</code></pre>

blocks|key|1604359|text|这适用于Framework+4.0或更高版本。支持GO。还会显示错误消息、行和sql命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1604360|using+System.Data.SqlClient;

++++++++private+bool+runSqlScriptFile(string+pathStoreProceduresFile,+string+connectionString)
++++{
++++++++try
++++++++{
++++++++++++string+script+=+File.ReadAllText(pathStoreProceduresFile);

++++++++++++//+split+script+on+GO+command
++++++++++++System.Collections.Generic.IEnumerable<string>+commandStrings+=+Regex.Split(script,+@"%5E\s*GO\s*$",
+++++++++++++++++++++++++++++++++++++RegexOptions.Multiline+%7C+RegexOptions.IgnoreCase);
++++++++++++using+(SqlConnection+connection+=+new+SqlConnection(connectionString))
++++++++++++{
++++++++++++++++connection.Open();
++++++++++++++++foreach+(string+commandString+in+commandStrings)
++++++++++++++++{
++++++++++++++++++++if+(commandString.Trim()+!=+"")
++++++++++++++++++++{
++++++++++++++++++++++++using+(var+command+=+new+SqlCommand(commandString,+connection))
++++++++++++++++++++++++{
++++++++++++++++++++++++try
++++++++++++++++++++++++{
++++++++++++++++++++++++++++command.ExecuteNonQuery();
++++++++++++++++++++++++}
++++++++++++++++++++++++catch+(SqlException+ex)
++++++++++++++++++++++++{
++++++++++++++++++++++++++++string+spError+=+commandString.Length+>+100+?+commandString.Substring(0,+100)+%2B+"+...\n..."+:+commandString;
++++++++++++++++++++++++++++MessageBox.Show(string.Format("Please+check+the+SqlServer+script.\nFile:+{0}+\nLine:+{1}+\nError:+{2}+\nSQL+Command:+\n{3}",+pathStoreProceduresFile,+ex.LineNumber,+ex.Message,+spError),+"Warning",+MessageBoxButtons.OK,+MessageBoxIcon.Warning);
++++++++++++++++++++++++++++return+false;
++++++++++++++++++++++++}
++++++++++++++++++++}
++++++++++++++++++++}
++++++++++++++++}
++++++++++++++++connection.Close();
++++++++++++}
++++++++return+true;
++++++++}
++++++++catch+(Exception+ex)
++++++++{
++++++++++++MessageBox.Show(ex.Message,+"Warning",+MessageBoxButtons.OK,+MessageBoxIcon.Warning);
++++++++++++return+false;
++++++++}
++++}|code-block|syntax|javascript|1604361|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This Works on Framework 4.0 or Higher. Supports "GO". Also show the error message, line, and sql command.

<pre><code>using System.Data.SqlClient;

 private bool runSqlScriptFile(string pathStoreProceduresFile, string connectionString)
 {
 try
 {
 string script = File.ReadAllText(pathStoreProceduresFile);

 // split script on GO command
 System.Collections.Generic.IEnumerable&lt;string&gt; commandStrings = Regex.Split(script, @"^\s*GO\s*$",
 RegexOptions.Multiline | RegexOptions.IgnoreCase);
 using (SqlConnection connection = new SqlConnection(connectionString))
 {
 connection.Open();
 foreach (string commandString in commandStrings)
 {
 if (commandString.Trim() != "")
 {
 using (var command = new SqlCommand(commandString, connection))
 {
 try
 {
 command.ExecuteNonQuery();
 }
 catch (SqlException ex)
 {
 string spError = commandString.Length &gt; 100 ? commandString.Substring(0, 100) + " ...\n..." : commandString;
 MessageBox.Show(string.Format("Please check the SqlServer script.\nFile: {0} \nLine: {1} \nError: {2} \nSQL Command: \n{3}", pathStoreProceduresFile, ex.LineNumber, ex.Message, spError), "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
 return false;
 }
 }
 }
 }
 connection.Close();
 }
 return true;
 }
 catch (Exception ex)
 {
 MessageBox.Show(ex.Message, "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
 return false;
 }
 }
</code></pre>

blocks|key|1389478|text|使用EntityFramework，您可以使用这样的解决方案。我使用这段代码初始化e2e测试。为了防止sql注入攻击，请确保不根据用户输入或使用命令参数生成此脚本(请参阅接受参数的ExecuteSqlCommand重载)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1389479|public+static+void+ExecuteSqlScript(string+sqlScript)
{
++++using+(MyEntities+dataModel+=+new+MyEntities())
++++{
++++++++//+split+script+on+GO+commands
++++++++IEnumerable<string>+commands+=+
++++++++++++Regex.Split(
++++++++++++++++sqlScript,+
++++++++++++++++@"%5E\s*GO\s*$",
++++++++++++++++RegexOptions.Multiline+%7C+RegexOptions.IgnoreCase);

++++++++foreach+(string+command+in+commands)
++++++++{
++++++++++++if+(command.Trim()+!=+string.Empty)
++++++++++++{
++++++++++++++++dataModel.Database.ExecuteSqlCommand(command);
++++++++++++}
++++++++}++++++++++++++
++++}
}|code-block|syntax|javascript|1389480|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Using EntityFramework, you can go with a solution like this.
I use this code to initialize e2e tests. De prevent sql injection attacks, make sure not to generate this script based on user input or use command parameters for this (see overload of ExecuteSqlCommand that accepts parameters).

<pre><code>public static void ExecuteSqlScript(string sqlScript)
{
 using (MyEntities dataModel = new MyEntities())
 {
 // split script on GO commands
 IEnumerable&lt;string&gt; commands = 
 Regex.Split(
 sqlScript, 
 @"^\s*GO\s*$",
 RegexOptions.Multiline | RegexOptions.IgnoreCase);

 foreach (string command in commands)
 {
 if (command.Trim() != string.Empty)
 {
 dataModel.Database.ExecuteSqlCommand(command);
 }
 } 
 }
}
</code></pre>

blocks|key|1604458|text|我找不到任何确切有效的方法来做到这一点。所以在一整天之后，我带来了来自不同来源的混合代码，并试图完成这项工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1604459|但是，即使它成功地运行了脚本文件，它仍然生成一个异常ExecuteNonQuery:+CommandText+property+has+not+been+Initialized+--在我的例子中，它在第一次启动时成功地创建了数据库并插入了数据。|offset|length|style|CODE|1604460|public+partial+class+Form1+:+MetroForm
{
++++SqlConnection+cn;
++++SqlCommand+cm;
++++public+Form1()
++++{
++++++++InitializeComponent();
++++}

++++private+void+Form1_Load(object+sender,+EventArgs+e)
++++{
++++++++if+(!CheckDatabaseExist())
++++++++{
++++++++++++GenerateDatabase();
++++++++}
++++}

++++private+bool+CheckDatabaseExist()
++++{
++++++++SqlConnection+con+=+new+SqlConnection(@"Data+Source=.\SQLEXPRESS;Initial+Catalog=SalmanTradersDB;Integrated+Security=true");
++++++++try
++++++++{
++++++++++++con.Open();
++++++++++++return+true;
++++++++}
++++++++catch
++++++++{
++++++++++++return+false;
++++++++}
++++}

++++private+void+GenerateDatabase()
++++{

++++++++try
++++++++{
++++++++++++cn+=+new+SqlConnection(@"Data+Source=.\SQLEXPRESS;Initial+Catalog=master;Integrated+Security=True");
++++++++++++StringBuilder+sb+=+new+StringBuilder();
++++++++++++sb.Append(string.Format("drop+databse+{0}",+"SalmanTradersDB"));
++++++++++++cm+=+new+SqlCommand(sb.ToString()+,+cn);
++++++++++++cn.Open();
++++++++++++cm.ExecuteNonQuery();
++++++++++++cn.Close();
++++++++}
++++++++catch
++++++++{

++++++++}
++++++++try
++++++++{
++++++++++++//Application.StartupPath+is+the+location+where+the+application+is+Installed
++++++++++++//Here+File+Path+Can+Be+Provided+Via+OpenFileDialog
++++++++++++if+(File.Exists(Application.StartupPath+%2B+"\\script.sql"))
++++++++++++{
++++++++++++++++string+script+=+null;
++++++++++++++++script+=+File.ReadAllText(Application.StartupPath+%2B+"\\script.sql");
++++++++++++++++string[]+ScriptSplitter+=+script.Split(new+string[]+{+"GO"+},+StringSplitOptions.None);
++++++++++++++++using+(cn+=+new+SqlConnection(@"Data+Source=.\SQLEXPRESS;Initial+Catalog=master;Integrated+Security=True"))
++++++++++++++++{
++++++++++++++++++++cn.Open();
++++++++++++++++++++foreach+(string+str+in+ScriptSplitter)
++++++++++++++++++++{
++++++++++++++++++++++++using+(cm+=+cn.CreateCommand())
++++++++++++++++++++++++{
++++++++++++++++++++++++++++cm.CommandText+=+str;
++++++++++++++++++++++++++++cm.ExecuteNonQuery();
++++++++++++++++++++++++}
++++++++++++++++++++}
++++++++++++++++}
++++++++++++}
++++++++}
++++++++catch
++++++++{

++++++++}

++++}

}|code-block|syntax|javascript|1604461|entityMap^0|0|Q|1Q|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|S|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I couldn't find any exact and valid way to do this. So after a whole day, I came with this mixed code achieved from different sources and trying to get the job done.

But it is still generating an exception <code>ExecuteNonQuery: CommandText property has not been Initialized</code> even though it successfully runs the script file - in my case, it successfully creates the database and inserts data on the first startup.

<pre><code>public partial class Form1 : MetroForm
{
 SqlConnection cn;
 SqlCommand cm;
 public Form1()
 {
 InitializeComponent();
 }

 private void Form1_Load(object sender, EventArgs e)
 {
 if (!CheckDatabaseExist())
 {
 GenerateDatabase();
 }
 }

 private bool CheckDatabaseExist()
 {
 SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=SalmanTradersDB;Integrated Security=true");
 try
 {
 con.Open();
 return true;
 }
 catch
 {
 return false;
 }
 }

 private void GenerateDatabase()
 {

 try
 {
 cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=master;Integrated Security=True");
 StringBuilder sb = new StringBuilder();
 sb.Append(string.Format("drop databse {0}", "SalmanTradersDB"));
 cm = new SqlCommand(sb.ToString() , cn);
 cn.Open();
 cm.ExecuteNonQuery();
 cn.Close();
 }
 catch
 {

 }
 try
 {
 //Application.StartupPath is the location where the application is Installed
 //Here File Path Can Be Provided Via OpenFileDialog
 if (File.Exists(Application.StartupPath + "\\script.sql"))
 {
 string script = null;
 script = File.ReadAllText(Application.StartupPath + "\\script.sql");
 string[] ScriptSplitter = script.Split(new string[] { "GO" }, StringSplitOptions.None);
 using (cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=master;Integrated Security=True"))
 {
 cn.Open();
 foreach (string str in ScriptSplitter)
 {
 using (cm = cn.CreateCommand())
 {
 cm.CommandText = str;
 cm.ExecuteNonQuery();
 }
 }
 }
 }
 }
 catch
 {

 }

 }

}
</code></pre>

I'm sure this question has been answered already, however I was unable to find an answer using the search tool.

Using c# I'd like to run a .sql file. The sql file contains multiple sql statements, some of which are broken over multiple lines. I tried reading in the file and tried executing the file using ODP.NET ... however I don't think ExecuteNonQuery is really designed to do this.

So I tried using sqlplus via spawning a process ... however unless I spawned the process with UseShellExecute set to true sqlplus would hang and never exit. Here's the code that DOESN'T WORK.

<pre><code>Process p = new Process();
p.StartInfo.UseShellExecute = false;
p.StartInfo.RedirectStandardOutput = true;
p.StartInfo.FileName = "sqlplus";
p.StartInfo.Arguments = string.Format("xx/xx@{0} @{1}", in_database, s);
p.StartInfo.CreateNoWindow = true;

bool started = p.Start();
p.WaitForExit();
</code></pre>

WaitForExit never returns .... Unless I set UseShellExecute to true. A side effect of UseShellExecute is that you can no capture the redirected output.

How to execute an .SQL script file using c#

数据库

我确信这个问题已经得到了回答，但是我无法使用搜索工具找到答案。使用c#，我想运行一个.sql文件。sql文件包含多个sql语句，其中一些语句被分成多行。我尝试读取文件，并尝试使用ODP.NET执行文件...然而，我并不认为ExecuteNonQuery真的是为此而设计的。所以我试着通过派生一个进程来使用sqlplus ...

问如何使用c#执行.SQL脚本文件
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用c#执行.SQL脚本文件EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用c#执行.SQL脚本文件
EN