public void VerifyProjectType()
        {
            IProjectType projectType = BusinessObjectInitializer.CreateProjectType();

            Random random = new Random();

            projectType.Type = DATestUtils.GenerateString(20, true, false);
            projectType.Rank = random.Next(100000, 200000);

            int newId = InsertProjectTypeTest(projectType);

            Assert.Greater(newId, 0);

            int rowsAffected = UpdateProjectTypeTest(projectType);

            Assert.AreEqual(1, rowsAffected);

            DataTable resultTable = SelectProjectTypeTest(projectType).Tables[0];

            //Verifies that the table contains the correct column names and order
            StringCollection columns = new StringCollection();

            columns.AddRange(new string[] { "Type",
                                            "Rank",
                                            "Id" });

            DATestUtils.CheckTableStructure(resultTable, columns);

            int rowCount = DeleteProjectTypeTest(projectType);

            Assert.AreEqual(1, rowCount);
        }