コード例 #1
0
 public static DataStoreBacktest GetInstance(string databasePath)
 {
     if (!DatabaseInstances.ContainsKey(databasePath))
     {
         DatabaseInstances[databasePath] = new DataStoreBacktest(databasePath);
     }
     return(DatabaseInstances[databasePath]);
 }
コード例 #2
0
        protected override IList <TreeNodeBase> GetNodes()
        {
            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 database instances ...");
                        var infoProvider = DatabaseConnection.DatabaseServer.GetInfoProvider();
                        DatabaseInstances.Clear();
                        DatabaseInstances.AddRange(infoProvider.GetDatabaseInstances(connection));
                        _log.DebugFormat("Loaded {0} databases instance(s).", DatabaseInstances.Count);

                        _log.Debug("Creating nodes ...");
                        var databaseInstanceNodes = new List <TreeNodeBase>();
                        var csb = new SqlConnectionStringBuilder(DatabaseConnection.ConnectionString);
                        foreach (var databaseInstance in DatabaseInstances)
                        {
                            csb.InitialCatalog = databaseInstance.Name;
                            var dbConnection = (DatabaseConnection)DatabaseConnection.Clone();
                            dbConnection.ConnectionString = csb.ConnectionString;
                            dbConnection.IsConnected      = false;
                            var node = new SqlServerDatabaseInstanceTreeNode(databaseInstance, dbConnection);
                            databaseInstanceNodes.Add(node);
                        }
                        _log.Debug("Loading nodes finished.");
                        return(databaseInstanceNodes);

//                        _log.Debug("Creating nodes ...");
//                        var nodes =
//                            DatabaseInstances.Select(schema => new SqlServerDatabaseInstanceTreeNode(schema, DatabaseConnection)).Cast<TreeNodeBase>().ToList();
//                        _log.Debug("Loading nodes finished.");
//                        return nodes;
                    }
                }
            }
            catch (Exception ex)
            {
                DatabaseConnection.Disconnect();
                _log.ErrorFormat("Error opening connection and loading data.");
                _log.Error(ex.Message, ex);
                throw;
            }
        }