private void refreshToolStripMenuItem1_Click(object sender, EventArgs e) { var db = SelectedDBObject as DB; DBManager.Refresh(db); var db_node = tree_existing.SelectedNode; db_node.Nodes.Clear(); foreach (TreeNode n in db.GetTree().Nodes) { db_node.Nodes.Add(n); } IconizeTreeNodes(db_node); }
public static void Refresh(DBObject o) { //redirect to proper manager if (o is DB) { DBManager.Refresh(o as DB); } else if (o is DBSchema) { DBSchemaManager.Refresh(o as DBSchema); } else if (o is DBTable) { DBTableManager.Refresh(o as DBTable); } else if (o is DBView) { DBViewManager.Refresh(o as DBView); } }
public static void Refresh(DBConnection c) { const string sql = "select name from sys.databases order by name"; var cmd = new DBCommand { Sql = sql, Owner = new DBObject { Connection = c }, Description = "Get Databases" }; c.Databases.Clear(); c.Databases.AddRange(DBProjectManager.ExecuteQuery(cmd).AsEnumerable().Select(x => new DB() { Name = x["name"].ToString(), Connection = c }).ToList()); var initial_db = c.Databases.FirstOrDefault(x => x.Name == c.InitialDatabase); DBManager.Refresh(initial_db); }