public void TestPKRename() { SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=Door_Production;" + "Integrated Security=true"); DbStructure structure = new DbStructure(); structure.FillStructure(conn); Table t = structure.Tables.FirstOrDefault(x => x.Name == "Door"); t.RenameColumnPK("Door_ID", conn); }
private void buttonChangedColumn_Click(object sender, RoutedEventArgs e) { int index_table = ListTables.SelectedIndex; int index_column = ListColums.SelectedIndex; structure.Tables[index_table].RenameColumn(structure.Tables[index_table].Columns[index_column], textBoxChangedColumn.Text, structure.Connection); ListTables.UnselectAll(); ListColums.UnselectAll(); ListTables.Items.Clear(); ListColums.Items.Clear(); structure.FillStructure(structure.Connection); for (int i = 0; i < structure.Tables.Count; i++) { ListTables.Items.Add(structure.Tables[i].Name); } ListTables.SelectedIndex = index_table; ListColums.SelectedIndex = index_column; }
public void TestStructureInitialization() { SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=Door_Production;" + "Integrated Security=true"); DbStructure structure = new DbStructure(); structure.FillStructure(conn); Console.WriteLine(structure.DataBaseName + "\n"); foreach (var tab in structure.Tables) { Console.WriteLine(tab.Name); } }
private void MenuItem_Click_6(object sender, RoutedEventArgs e) { Structure.FillStructure(Connector.GetConnection(Connector.Name, Connector.Password, Connector.Db_name)); generalFrame.Navigate(tableUserControl); tableUserControl.Update(Structure); }