private static void ExecuteSql(UpdateContext context, string rawSqlText)
{
Regex regex = new Regex("^\\s*GO\\s*$", RegexOptions.IgnoreCase | RegexOptions.Multiline);
string[] lines = regex.Split(rawSqlText);
using (SqlCommand cmd = context.Connection.CreateCommand())
{
cmd.Connection = context.Connection;
cmd.Transaction = context.Transaction;
cmd.CommandTimeout = context.CommandTimeout;
foreach (string line in lines)
{
if (line.Length > 0)
{
try
{
cmd.CommandText = line;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine("Unexpected error with line in upgrade script: {0}", line);
Console.WriteLine("Error: {0}", e.Message);
throw;
}
}
}
}
}
private static void ExecuteSql(UpdateContext context, string rawSqlText)
{
Regex regex = new Regex("^\\s*GO\\s*$", RegexOptions.IgnoreCase | RegexOptions.Multiline);
string[] lines = regex.Split(rawSqlText);
using (SqlCommand cmd = context.Connection.CreateCommand())
{
cmd.Connection = context.Connection;
cmd.Transaction = context.Transaction;
foreach (string line in lines)
{
if (line.Length > 0)
{
cmd.CommandText = line;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
}
}
}
