public void VerifyDepartment() { Random random = new Random(); IDepartment department = BusinessObjectInitializer.CreateDepartment(); department.Name = DATestUtils.GenerateString(30, true, false); department.IdFunction = random.Next(1, 5); department.Rank = random.Next(100000, 200000); int newId = InsertDepartmentTest(department); Assert.Greater(newId, 0); int rowsAffected = UpdateDepartmentTest(department); Assert.AreEqual(1, rowsAffected); DataTable resultTable = SelectDepartmentTest(department).Tables[0]; //Verifies that the table contains the correct column names and order StringCollection columns = new StringCollection(); columns.AddRange(new string[] { "Name", "FunctionName", "Rank", "Id", "IdFunction", }); DATestUtils.CheckTableStructure(resultTable, columns); int rowCount = DeleteDepartmentTest(department); Assert.AreEqual(1, rowCount); }