public void ExamQueryReturnsCorrectDatabasePrefixForGivenType()
        {
            //Arrange
            ExamQuery criteria = new ExamQuery();
            //Act
            var nResponse = criteria.getDatabasePrefix("FIRST_NAME");
            var aReponse  = criteria.getDatabasePrefix("DESCRIPTION");
            var fResponse = criteria.getDatabasePrefix("FIRM_NO");

            //Assert
            Assert.AreEqual("n.", nResponse);
            Assert.AreEqual("a.", aReponse);
            Assert.AreEqual("ar.", fResponse);
        }
        public void ExamQueryReturnsCorrectDatabasePrefixForcr()
        {
            //Arrange
            ExamQuery criteria = new ExamQuery();
            //Act
            var crHeaders = new string[1] {
                "STUDENT_ID"
            };

            //Assert
            foreach (string header in crHeaders)
            {
                Assert.AreEqual("cr.", criteria.getDatabasePrefix(header));
            }
        }
        public void ExamQueryReturnsCorrectDatabasePrefixForar()
        {
            //Arrange
            ExamQuery criteria = new ExamQuery();
            //Act
            var arHeaders = new string[1] {
                "FIRM_NO"
            };

            //Assert
            foreach (string header in arHeaders)
            {
                Assert.AreEqual("ar.", criteria.getDatabasePrefix(header));
            }
        }
        public void ExamQueryReturnsCorrectDatabasePrefixForn()
        {
            //Arrange
            ExamQuery criteria = new ExamQuery();
            //Act
            var nHeaders = new string[4] {
                "MAJOR_KEY", "FIRST_NAME", "MIDDLE_NAME", "LAST_NAME"
            };

            //Assert
            foreach (string header in nHeaders)
            {
                Assert.AreEqual("n.", criteria.getDatabasePrefix(header));
            }
        }