public void VerifyHourlyRate()
        {
            Random random = new Random();

            IHourlyRate hourlyRate = BusinessObjectInitializer.CreateHourlyRate();

            hourlyRate.YearMonth    = random.Next(2010, 2079) * 100 + random.Next(1, 12);
            hourlyRate.IdCurrency   = random.Next(1, 12);
            hourlyRate.IdCostCenter = random.Next(1, 3);
            hourlyRate.Value        = DATestUtils.DEFAULT_DECIMAL_VALUE;

            int newId = InsertHourlyRateTest(hourlyRate);

            Assert.AreEqual(newId, 0);

            int rowsAffected = UpdateHourlyRateTest(hourlyRate);

            Assert.AreEqual(1, rowsAffected);

            DataTable resultTable = SelectHourlyRateTest(hourlyRate).Tables[0];

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

            columns.AddRange(new string[] { "InergyLocationName",
                                            "CostCenterCode",
                                            "CurrencyName",
                                            "Value",
                                            "YearMonth",
                                            "CostCenterName",
                                            "IdInergyLocation",
                                            "IdCostCenter",
                                            "IdCurrency" });

            DATestUtils.CheckTableStructure(resultTable, columns);

            int rowCount = DeleteHourlyRateTest(hourlyRate);

            Assert.AreEqual(1, rowCount);
        }