private void Button_Click_2(object sender, RoutedEventArgs e) { try { Convention currentConvention = Conventions.Conventions[dataGridPatterns.SelectedIndex]; for (int i = 0; i < mWindow.Structure.Tables.Count; i++) { mWindow.Structure.Tables[i].Rename( currentConvention.GetTableName(mWindow.Structure.Tables[i].Name), mWindow.Structure.Connection); mWindow.Structure.Tables[i].Name = currentConvention.GetTableName(mWindow.Structure.Tables[i].Name); for (int j = 0; j < mWindow.Structure.Tables[i].Columns.Count; j++) { mWindow.Structure.Tables[i].RenameColumn( mWindow.Structure.Tables[i].Columns[j], currentConvention.GetColumnName(mWindow.Structure.Tables[i].Columns[j].Name, mWindow.Structure.Tables[i].Name), mWindow.Structure.Connection); } string qs = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE OBJECTPROPERTY(OBJECT_ID(CONSTRAINT_SCHEMA + '.' + QUOTENAME(CONSTRAINT_NAME)), 'IsPrimaryKey') = 1 AND TABLE_NAME = '" + mWindow.Structure.Tables[i].Name + "'"; SqlCommand comm = new SqlCommand(qs, mWindow.Structure.Connection); Object r = comm.ExecuteScalar(); if (r != null) { string colName = r.ToString(); mWindow.Structure.Tables[i].RenameColumnPK( currentConvention.GetPrimaryKeyName(colName, mWindow.Structure.Tables[i].Name), mWindow.Structure.Connection); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void PrimaryKeyTestMethod() { Convention con = new Convention("conv", ":MainPart:__++__:mainPart:", ":tName:_:MainPart:Column", ":TName:_ID", true); Console.WriteLine(con.GetPrimaryKeyName("ID", "Door")); }