static void Main(string[] args) { var gen = new XmlTemplateReader(); Console.Write(gen.ReadInsertStoredProcedure("Cources", "WindowsLearner")); Console.Write(gen.ReadUpdateStoredProcedure("Cources", "WindowsLearner")); Console.Write(gen.ReadSelectStoredProcedure("Cources", "WindowsLearner")); Console.Write(gen.ReadSelectAllStoredProcedure("Cources", "WindowsLearner")); Console.Write(gen.ReadDeleteStoredProcedure("Cources", "WindowsLearner")); Console.ReadLine(); }
private void ButtonGenerate_Click(object sender, RoutedEventArgs e) { var gen = new XmlTemplateReader(); StringBuilder allSps = new StringBuilder(); ConnectionStringRefresher.RefreshConnectionStringInConfigurationFile(TextConnectionString.Text); allSps.Append(gen.ReadInsertStoredProcedure((string)ComboTables.SelectedValue, (string)ComboDBs.SelectedValue)); allSps.Append(gen.ReadUpdateStoredProcedure((string)ComboTables.SelectedValue, (string)ComboDBs.SelectedValue)); allSps.Append(gen.ReadSelectStoredProcedure((string)ComboTables.SelectedValue, (string)ComboDBs.SelectedValue)); allSps.Append(gen.ReadSelectAllStoredProcedure((string)ComboTables.SelectedValue, (string)ComboDBs.SelectedValue)); allSps.Append(gen.ReadDeleteStoredProcedure((string)ComboTables.SelectedValue, (string)ComboDBs.SelectedValue)); RichTextBox.Text = allSps.ToString(); }