protected override IList <TreeNodeBase> GetNodes()
{
var nodes = new List <TreeNodeBase>();
var schemasTreeNode = new SchemasTreeNode(DatabaseConnection, DatabaseInstance);
nodes.Add(schemasTreeNode);
return(nodes);
//try
//{
// var actionName = string.Format("Attempting to connect to {0} ...", DatabaseConnection.Name);
// _log.Debug(actionName);
// using (new WaitActionStatus(actionName))
// {
// _log.DebugFormat("Creating connection for {0} ...", DatabaseConnection.Name);
// using (var connection = DatabaseConnection.CreateNewConnection())
// {
// connection.OpenIfRequired();
// DatabaseConnection.Connect();
// _log.Debug("Connection is successful.");
// _log.Debug("Loading schemas ...");
// var infoProvider = DatabaseConnection.DatabaseServer.GetInfoProvider();
// Schemas.Clear();
// Schemas.AddRange(infoProvider.GetSchemas(connection));
// _log.DebugFormat("Loaded {0} schema(s).", Schemas.Count);
// _log.Debug("Creating nodes ...");
// var schemNodes =
// Schemas.Select(schema => new Db2SchemaTreeNode(schema, DatabaseConnection)).Cast<TreeNodeBase>().ToList();
// _log.Debug("Loading nodes finished.");
// return schemNodes;
// }
// }
//}
//catch (Exception ex)
//{
// DatabaseConnection.Disconnect();
// _log.ErrorFormat("Error opening connection and loading data.");
// _log.Error(ex.Message, ex);
// throw;
//}
}
protected override IList <TreeNodeBase> GetNodes()
{
var nodes = new List <TreeNodeBase>();
var schemasTreeNode = new SchemasTreeNode(DatabaseConnection, DatabaseInstance);
nodes.Add(schemasTreeNode);
return(nodes);
// try
// {
// var actionName = string.Format("Fetching databases for {0} ...", DatabaseConnection.Name);
// using (new WaitActionStatus(actionName))
// {
// using (var connection = DatabaseConnection.CreateNewConnection())
// {
// connection.OpenIfRequired();
// DatabaseConnection.Connect();
// _log.Debug("Connection is successful.");
// _log.Debug("Loading database instances ...");
// var infoProvider = DatabaseConnection.DatabaseServer.GetInfoProvider();
// var schemas = infoProvider.GetSchemas(connection, DatabaseInstance.Name);
// foreach (var schema in schemas)
// {
// schema.Parent = DatabaseInstance;
// }
// _log.DebugFormat("Loaded {0} database instance(s).", schemas.Count);
//
// _log.Debug("Creating nodes ...");
// var schemNodes =
// schemas.Select(schema => new SqlServerSchemaTreeNode(schema, DatabaseConnection, DatabaseInstance)).Cast<TreeNodeBase>().ToList();
// _log.Debug("Loading nodes finished.");
// return schemNodes;
// }
// }
// }
// catch (Exception ex)
// {
// DatabaseConnection.Disconnect();
// _log.ErrorFormat("Error fetching databases for {0}.", DatabaseConnection.Name);
// _log.Error(ex.Message, ex);
// throw;
// }
}
