public bool IsEntityFrameworkPointingToTest(Data.KeyCdrDataEntities db)
        {
            //test the entity framework database
            if (!db.Database.Connection.Database.Equals(TEST_DB_NAME))
            {
                return(false);
            }

            //test the entity framework connection string
            if (!IsConnStringPointingToTestDB(db.Database.Connection.ConnectionString))
            {
                return(false);
            }

            return(true);
        }
        public bool IsOnTestDB()
        {
            //test connection string
            string connectionString = GetAppConfigConnectionString();

            if (!IsConnStringPointingToTestDB(connectionString))
            {
                return(false);
            }

            Data.KeyCdrDataEntities db = new Data.KeyCdrDataEntities();
            if (!IsEntityFrameworkPointingToTest(db))
            {
                return(false);
            }

            return(true);
        }
Пример #3
0
        public void Reset()
        {
            Data.KeyCdrDataEntities db = new Data.KeyCdrDataEntities();

            TestDatabaseEnsurer ensurer = new TestDatabaseEnsurer();

            if (!ensurer.IsEntityFrameworkPointingToTest(db))
            {
                throw new Exception("not configured or pointing to the test environment...yikes!");
            }

            db.Database.ExecuteSqlCommand(GetClearCmd("KCUserLogin"));
            db.Database.ExecuteSqlCommand(GetClearCmd("AnalysisAccuracy"));
            db.Database.ExecuteSqlCommand(GetClearCmd("AnalysisSpeed"));
            db.Database.ExecuteSqlCommand(GetClearCmd("KeySequenceAnalysis"));
            db.Database.ExecuteSqlCommand(GetClearCmd("KeySequence"));
            db.Database.ExecuteSqlCommand(GetClearCmd("Session"));
            db.Database.ExecuteSqlCommand(GetClearCmd("KCUser"));
        }