public SqlServerStatusHandlerTester()
        {
            string dbName = "LoaderStatusHandlerTestDB";
            LocalDb.CreateLocalDb(dbName, DBCreatorScripts.GetSqlStatusHandlerTestSqlSetup(), true);

           // _connection = LocalDb.GetConnectionString(dbName);  

            _handler = new SQLServerStatusHandler(LocalDb.GetConnectionString(dbName));
            //string test = "";
        }
        public void RunTestLoaderTest()
        {
            //string connection = @"Data Source=localhost\SQLEXPRESS;Database=LoaderDB;Integrated Security=True;";
            
            ILoaderConfigHandler configHandler= new SQLServerLoaderConfigHandler(_connection);
            IStatusHandler statusHandler = new SQLServerStatusHandler(_connection);

            TestDataLoader loader = new TestDataLoader();
            loader.InitializeHandlers(configHandler, statusHandler);
            loader.RunDataLoader();

            bool callCountOK = loader.CallCount == 5;
            bool configCountOK = loader.ConfigCount == 7;

            Assert.True(callCountOK && configCountOK);
        }