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(); } } } }