private void RunCommands(DataSet dataset, string script, bool checkSyntax, bool includePlan, bool ignoreDdlErrors = false)
{
dataset.EnforceConstraints = false;
using (SqlCeCommand cmd = new SqlCeCommand())
{
cmd.Connection = _cn;
if (checkSyntax)
{
cmd.CommandText = "SET SHOWPLAN_XML ON;";
cmd.ExecuteNonQuery();
}
if (includePlan)
{
cmd.CommandText = "SET STATISTICS XML ON;";
cmd.ExecuteNonQuery();
}
using (SqlCommandReader reader = new SqlCommandReader(script))
{
var commandText = reader.ReadCommand();
while (!string.IsNullOrWhiteSpace(commandText))
{
RunCommand(commandText, dataset, ignoreDdlErrors);
commandText = reader.ReadCommand();
}
}
if (checkSyntax)
{
cmd.CommandText = "SELECT @@SHOWPLAN;";
var obj = cmd.ExecuteScalar();
var s = obj as string;
if (s != null)
{
_showPlan = s;
}
cmd.CommandText = "SET SHOWPLAN_XML OFF;";
cmd.ExecuteNonQuery();
}
if (includePlan)
{
cmd.CommandText = "SELECT @@SHOWPLAN;";
var obj = cmd.ExecuteScalar();
var s = obj as string;
if (s != null)
{
_showPlan = s;
}
cmd.CommandText = "SET STATISTICS XML OFF;";
cmd.ExecuteNonQuery();
}
}
}
internal void RunCommands(DataSet dataset, string script, bool checkSyntax, bool includePlan, bool ignoreDDLErrors = false)
{
dataset.EnforceConstraints = false;
using (SqlCeCommand cmd = new SqlCeCommand())
{
cmd.Connection = cn;
if (checkSyntax)
{
cmd.CommandText = "SET SHOWPLAN_XML ON;";
cmd.ExecuteNonQuery();
}
if (includePlan)
{
cmd.CommandText = "SET STATISTICS XML ON;";
cmd.ExecuteNonQuery();
}
using (SqlCommandReader reader = new SqlCommandReader(script))
{
var commandText = reader.ReadCommand();
while (!string.IsNullOrWhiteSpace(commandText))
{
RunCommand(commandText, dataset, ignoreDDLErrors);
commandText = reader.ReadCommand();
}
}
if (checkSyntax)
{
cmd.CommandText = "SELECT @@SHOWPLAN;";
object obj = cmd.ExecuteScalar();
if (obj.GetType() == typeof(System.String))
{
showPlan = (string)obj;
}
cmd.CommandText = "SET SHOWPLAN_XML OFF;";
cmd.ExecuteNonQuery();
}
if (includePlan)
{
cmd.CommandText = "SELECT @@SHOWPLAN;";
object obj = cmd.ExecuteScalar();
if (obj.GetType() == typeof(System.String))
{
showPlan = (string)obj;
}
cmd.CommandText = "SET STATISTICS XML OFF;";
cmd.ExecuteNonQuery();
}
}
}
internal void RunCommands(SqlCeCmd.Program.Options options)
{
using (var sr = new SqlCommandReader(options.QueryFile))
{
var commandText = sr.ReadCommand();
while (!string.IsNullOrWhiteSpace(commandText))
{
if (!options.HideOutput)
{
Console.WriteLine("Executing: " + commandText);
}
options.QueryText = commandText;
RunCommand(options);
commandText = sr.ReadCommand();
}
}
}
internal void RunCommands(DataSet dataset, string script, bool checkSyntax, bool includePlan, bool ignoreDDLErrors = false)
{
dataset.EnforceConstraints = false;
using (SQLiteCommand cmd = new SQLiteCommand())
{
cmd.Connection = cn;
using (SqlCommandReader reader = new SqlCommandReader(script))
{
var commandText = reader.ReadCommand();
while (!string.IsNullOrWhiteSpace(commandText))
{
if (includePlan)
{
commandText = "EXPLAIN QUERY PLAN " + commandText;
}
RunCommand(commandText, dataset, ignoreDDLErrors);
commandText = reader.ReadCommand();
}
}
}
}
