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