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