public void Test_10_Delete_Country()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(10, country.Country_ID);
            subContinent.G05_CountryObjects.Remove(10);
            continent = continent.Save();

            country.Country_Name = "Deleted";
            try
            {
                continent = continent.Save();
                Assert.Fail(country.Country_Name + " wasn't deleted.");
            }
            catch (Csla.DataPortalException ex)
            {
                //Assert.Fail(ex.GetBaseException().Message);
            }

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(0, subContinent.G05_CountryObjects.Count);
        }
        public void Test_20_Edit_City()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            var region = country.G07_RegionObjects[0];
            Assert.AreEqual(1, region.G09_CityObjects.Count);
            var city = region.G09_CityObjects.FindG10_CityByCity_ID(29);
            city.City_Name += " Edited";
            city.G11_City_SingleObject.City_Child_Name += " Edited";
            city.G11_City_ASingleObject.City_Child_Name += " Edited";
            continent = continent.Save();

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(1, region.G09_CityObjects.Count);
            city = region.G09_CityObjects[0];
            Assert.AreEqual(CityName + " Edited", city.City_Name);
            Assert.AreEqual(CityName + " Child" + " Edited", city.G11_City_SingleObject.City_Child_Name);
            Assert.AreEqual(CityName + " ReChild" + " Edited", city.G11_City_ASingleObject.City_Child_Name);
        }
        public void Test_15_Add_Region()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(0, country.G07_RegionObjects.Count);
            var region = country.G07_RegionObjects.AddNew();
            region.Region_Name = RegionName;
            region.G09_Region_SingleObject.Region_Child_Name = RegionName + " Child";
            region.G09_Region_ASingleObject.Region_Child_Name = RegionName + " ReChild";
            continent = continent.Save();

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(29, region.Region_ID);

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(RegionName, region.Region_Name);
            Assert.AreEqual(RegionName + " Child", region.G09_Region_SingleObject.Region_Child_Name);
            Assert.AreEqual(RegionName + " ReChild", region.G09_Region_ASingleObject.Region_Child_Name);
        }
        public void Test_13_Add_Region_To_Delete()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(0, country.G07_RegionObjects.Count);
            var region = country.G07_RegionObjects.AddNew();
            region.Region_Name = RegionName;
            continent = continent.Save();

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(28, region.Region_ID);

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(RegionName, region.Region_Name);
        }
        public void Test_16_Edit_Region()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            var region = country.G07_RegionObjects.FindG08_RegionByRegion_ID(29);
            region.Region_Name += " Edited";
            region.G09_Region_SingleObject.Region_Child_Name += " Edited";
            region.G09_Region_ASingleObject.Region_Child_Name += " Edited";
            continent = continent.Save();

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(RegionName + " Edited", region.Region_Name);
            Assert.AreEqual(RegionName + " Child" + " Edited", region.G09_Region_SingleObject.Region_Child_Name);
            Assert.AreEqual(RegionName + " ReChild" + " Edited", region.G09_Region_ASingleObject.Region_Child_Name);
        }
        public void Test_17_Add_City_To_Delete()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            var region = country.G07_RegionObjects[0];
            Assert.AreEqual(0, region.G09_CityObjects.Count);
            var city = region.G09_CityObjects.AddNew();
            city.City_Name = CityName;
            continent = continent.Save();

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(1, region.G09_CityObjects.Count);
            city = region.G09_CityObjects[0];
            Assert.AreEqual(28, city.City_ID);

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(1, region.G09_CityObjects.Count);
            city = region.G09_CityObjects[0];
            Assert.AreEqual(CityName, city.City_Name);
        }
        public void Test_18_Delete_City()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            var region = country.G07_RegionObjects[0];
            Assert.AreEqual(1, region.G09_CityObjects.Count);
            var city = region.G09_CityObjects[0];
            Assert.AreEqual(28, city.City_ID);
            region.G09_CityObjects.Remove(28);
            continent = continent.Save();

            city.City_Name = "Deleted";
            try
            {
                continent = continent.Save();
                Assert.Fail(city.City_Name + " wasn't deleted.");
            }
            catch (Csla.DataPortalException ex)
            {
                //Assert.Fail(ex.GetBaseException().Message);
            }

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(0, region.G09_CityObjects.Count);
        }
        public void Test_24_Edit_CityRoad()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            var region = country.G07_RegionObjects[0];
            Assert.AreEqual(1, region.G09_CityObjects.Count);
            var city = region.G09_CityObjects[0];
            Assert.AreEqual(1, city.G11_CityRoadObjects.Count);
            var cityRoad = city.G11_CityRoadObjects[0];
            cityRoad.CityRoad_Name += " Edited";
            continent = continent.Save();

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(1, region.G09_CityObjects.Count);
            city = region.G09_CityObjects[0];
            Assert.AreEqual(1, city.G11_CityRoadObjects.Count);
            cityRoad = city.G11_CityRoadObjects[0];
            Assert.AreEqual(CityRoadName + " Edited", cityRoad.CityRoad_Name);
        }
        public void Test_11_Add_Country()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(0, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects.AddNew();
            country.Country_Name = CountryName;
            country.G07_Country_SingleObject.Country_Child_Name = CountryName + " Child";
            country.G07_Country_ASingleObject.Country_Child_Name = CountryName + " ReChild";
            continent = continent.Save();

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(11, country.Country_ID);

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(CountryName, country.Country_Name);
            Assert.AreEqual(CountryName + " Child", country.G07_Country_SingleObject.Country_Child_Name);
            Assert.AreEqual(CountryName + " ReChild", country.G07_Country_ASingleObject.Country_Child_Name);
        }
        public void Test_1_Continent()
        {
            var continent = G02_Continent.GetG02_Continent(4);

            Assert.AreEqual(ContinentName, continent.Continent_Name);
            Assert.AreEqual(ContinentName + " Child", continent.G03_Continent_SingleObject.Continent_Child_Name);
            Assert.AreEqual(ContinentName + " ReChild", continent.G03_Continent_ASingleObject.Continent_Child_Name);
        }
        public void Test_01_Create_Continent_To_Delete()
        {
            var continent = G02_Continent.NewG02_Continent();
            continent.Continent_Name = ContinentName;
            continent = continent.Save();

            Assert.AreEqual(4, continent.Continent_ID);

            continent = G02_Continent.GetG02_Continent(4);
            Assert.AreEqual(ContinentName, continent.Continent_Name);
        }
        public void Test_2_SubContinent()
        {
            var continent = G02_Continent.GetG02_Continent(4);

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];

            Assert.AreEqual(7, subContinent.SubContinent_ID);
            Assert.AreEqual(SubContinentName, subContinent.SubContinent_Name);
            Assert.AreEqual(SubContinentName + " Child", subContinent.G05_SubContinent_SingleObject.SubContinent_Child_Name);
            Assert.AreEqual(SubContinentName + " ReChild", subContinent.G05_SubContinent_ASingleObject.SubContinent_Child_Name);
        }
        public void Test_04_Edit_Continent()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            continent.Continent_Name += " Edited";
            continent.G03_Continent_SingleObject.Continent_Child_Name += " Edited";
            continent.G03_Continent_ASingleObject.Continent_Child_Name += " Edited";
            continent = continent.Save();

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(ContinentName + " Edited", continent.Continent_Name);
            Assert.AreEqual(ContinentName + " Child" + " Edited", continent.G03_Continent_SingleObject.Continent_Child_Name);
            Assert.AreEqual(ContinentName + " ReChild" + " Edited", continent.G03_Continent_ASingleObject.Continent_Child_Name);
        }
        public void Test_3_Country()
        {
            var continent = G02_Continent.GetG02_Continent(4);

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];

            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];

            Assert.AreEqual(10, country.Country_ID);
            Assert.AreEqual(CountryName, country.Country_Name);
            Assert.AreEqual(CountryName + " Child", country.G07_Country_SingleObject.Country_Child_Name);
            Assert.AreEqual(CountryName + " ReChild", country.G07_Country_ASingleObject.Country_Child_Name);
        }
        public void Test_03_Create_Continent()
        {
            var continent = G02_Continent.NewG02_Continent();
            continent.Continent_Name = ContinentName;
            continent.G03_Continent_SingleObject.Continent_Child_Name = ContinentName + " Child";
            continent.G03_Continent_ASingleObject.Continent_Child_Name = ContinentName + " ReChild";
            continent = continent.Save();

            Assert.AreEqual(5, continent.Continent_ID);

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(ContinentName, continent.Continent_Name);
            Assert.AreEqual(ContinentName + " Child", continent.G03_Continent_SingleObject.Continent_Child_Name);
            Assert.AreEqual(ContinentName + " ReChild", continent.G03_Continent_ASingleObject.Continent_Child_Name);
        }
        public void Test_05_Add_SubContinent_To_Delete()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(0, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects.AddNew();
            subContinent.SubContinent_Name = SubContinentName;
            continent = continent.Save();

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(7, subContinent.SubContinent_ID);

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(SubContinentName, subContinent.SubContinent_Name);
        }
        public void Test_08_Edit_SubContinent()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects.FindG04_SubContinentBySubContinent_ID(8);
            subContinent.SubContinent_Name += " Edited";
            subContinent.G05_SubContinent_SingleObject.SubContinent_Child_Name += " Edited";
            subContinent.G05_SubContinent_ASingleObject.SubContinent_Child_Name += " Edited";
            continent = continent.Save();

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(SubContinentName + " Edited", subContinent.SubContinent_Name);
            Assert.AreEqual(SubContinentName + " Child" + " Edited", subContinent.G05_SubContinent_SingleObject.SubContinent_Child_Name);
            Assert.AreEqual(SubContinentName + " ReChild" + " Edited", subContinent.G05_SubContinent_ASingleObject.SubContinent_Child_Name);
        }
        public void Test_4_Region()
        {
            var continent = G02_Continent.GetG02_Continent(4);

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];

            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];

            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            var region = country.G07_RegionObjects[0];

            Assert.AreEqual(28, region.Region_ID);
            Assert.AreEqual(RegionName, region.Region_Name);
            Assert.AreEqual(RegionName + " Child", region.G09_Region_SingleObject.Region_Child_Name);
            Assert.AreEqual(RegionName + " ReChild", region.G09_Region_ASingleObject.Region_Child_Name);
        }
        public void Test_02_Delete_Continent()
        {
            var continent = G02_Continent.GetG02_Continent(4);
            G02_Continent.DeleteG02_Continent(4);

            continent.Continent_Name = "Deleted";
            try
            {
                continent = continent.Save();
                Assert.Fail(continent.Continent_Name + " wasn't deleted.");
            }
            catch (Csla.DataPortalException ex)
            {
                //Assert.Fail(ex.GetBaseException().Message);
            }

            continent = G02_Continent.GetG02_Continent(4);
            if (continent.Continent_ID == 4)
                Assert.Fail(continent.Continent_Name + " wasn't deleted.");
        }
        public void Test_23_Add_CityRoad()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            var region = country.G07_RegionObjects[0];
            Assert.AreEqual(1, region.G09_CityObjects.Count);
            var city = region.G09_CityObjects[0];
            Assert.AreEqual(0, city.G11_CityRoadObjects.Count);
            var cityRoad = city.G11_CityRoadObjects.AddNew();
            cityRoad.CityRoad_Name = CityRoadName;
            continent = continent.Save();

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(1, region.G09_CityObjects.Count);
            city = region.G09_CityObjects[0];
            Assert.AreEqual(1, city.G11_CityRoadObjects.Count);
            cityRoad = city.G11_CityRoadObjects[0];
            Assert.AreEqual(83, cityRoad.CityRoad_ID);

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(1, region.G09_CityObjects.Count);
            city = region.G09_CityObjects[0];
            Assert.AreEqual(1, city.G11_CityRoadObjects.Count);
            cityRoad = city.G11_CityRoadObjects[0];
            Assert.AreEqual(CityRoadName, cityRoad.CityRoad_Name);
        }
        public void Test_12_Edit_Country()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects.FindG06_CountryByCountry_ID(11);
            country.Country_Name += " Edited";
            country.G07_Country_SingleObject.Country_Child_Name += " Edited";
            country.G07_Country_ASingleObject.Country_Child_Name += " Edited";
            continent = continent.Save();

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(CountryName + " Edited", country.Country_Name);
            Assert.AreEqual(CountryName + " Child" + " Edited", country.G07_Country_SingleObject.Country_Child_Name);
            Assert.AreEqual(CountryName + " ReChild" + " Edited", country.G07_Country_ASingleObject.Country_Child_Name);
        }
        public void Test_07_Add_SubContinent()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(0, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects.AddNew();
            subContinent.SubContinent_Name = SubContinentName;
            subContinent.G05_SubContinent_SingleObject.SubContinent_Child_Name = SubContinentName + " Child";
            subContinent.G05_SubContinent_ASingleObject.SubContinent_Child_Name = SubContinentName + " ReChild";
            continent = continent.Save();

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(8, subContinent.SubContinent_ID);

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(SubContinentName, subContinent.SubContinent_Name);
            Assert.AreEqual(SubContinentName + " Child", subContinent.G05_SubContinent_SingleObject.SubContinent_Child_Name);
            Assert.AreEqual(SubContinentName + " ReChild", subContinent.G05_SubContinent_ASingleObject.SubContinent_Child_Name);
        }
        public void Test_5_City()
        {
            var continent = G02_Continent.GetG02_Continent(4);

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];

            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];

            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            var region = country.G07_RegionObjects[0];

            Assert.AreEqual(1, region.G09_CityObjects.Count);
            var city = region.G09_CityObjects[0];

            Assert.AreEqual(28, city.City_ID);
            Assert.AreEqual(CityName, city.City_Name);
            Assert.AreEqual(CityName + " Child", city.G11_City_SingleObject.City_Child_Name);
            Assert.AreEqual(CityName + " ReChild", city.G11_City_ASingleObject.City_Child_Name);
        }
        public void Test_6_CityRoad()
        {
            var continent = G02_Continent.GetG02_Continent(4);

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];

            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];

            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            var region = country.G07_RegionObjects[0];

            Assert.AreEqual(1, region.G09_CityObjects.Count);
            var city = region.G09_CityObjects[0];

            Assert.AreEqual(1, city.G11_CityRoadObjects.Count);
            var cityRoad = city.G11_CityRoadObjects[0];

            Assert.AreEqual(82, cityRoad.CityRoad_ID);
            Assert.AreEqual(CityRoadName, cityRoad.CityRoad_Name);
        }
        public void Test_19_Add_City()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            var region = country.G07_RegionObjects[0];
            Assert.AreEqual(0, region.G09_CityObjects.Count);
            var city = region.G09_CityObjects.AddNew();
            city.City_Name = CityName;
            city.G11_City_SingleObject.City_Child_Name = CityName + " Child";
            city.G11_City_ASingleObject.City_Child_Name = CityName + " ReChild";
            continent = continent.Save();

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(1, region.G09_CityObjects.Count);
            city = region.G09_CityObjects[0];
            Assert.AreEqual(29, city.City_ID);

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(1, country.G07_RegionObjects.Count);
            region = country.G07_RegionObjects[0];
            Assert.AreEqual(1, region.G09_CityObjects.Count);
            city = region.G09_CityObjects[0];
            Assert.AreEqual(CityName, city.City_Name);
            Assert.AreEqual(CityName + " Child", city.G11_City_SingleObject.City_Child_Name);
            Assert.AreEqual(CityName + " ReChild", city.G11_City_ASingleObject.City_Child_Name);
        }
        public void Test_09_Add_Country_To_Delete()
        {
            var continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            var subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(0, subContinent.G05_CountryObjects.Count);
            var country = subContinent.G05_CountryObjects.AddNew();
            country.Country_Name = CountryName;
            continent = continent.Save();

            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(10, country.Country_ID);

            continent = G02_Continent.GetG02_Continent(5);
            Assert.AreEqual(1, continent.G03_SubContinentObjects.Count);
            subContinent = continent.G03_SubContinentObjects[0];
            Assert.AreEqual(1, subContinent.G05_CountryObjects.Count);
            country = subContinent.G05_CountryObjects[0];
            Assert.AreEqual(CountryName, country.Country_Name);
        }
// ReSharper disable InconsistentNaming
        public void FetchTest()
        {
            var g02_Continent = G02_Continent.GetG02_Continent(1);

            Console.WriteLine("Continent: " + g02_Continent.Continent_Name);
            Console.WriteLine("- Person = " + g02_Continent.G03_Continent_SingleObject.Continent_Child_Name);
            Console.WriteLine("- People = " + g02_Continent.G03_Continent_ASingleObject.Continent_Child_Name);
            foreach (var g04_SubContinent in g02_Continent.G03_SubContinentObjects)
            {
                Console.WriteLine("\tSub-continent: " + g04_SubContinent.SubContinent_Name);
                Console.WriteLine("\t- Person = " + g04_SubContinent.G05_SubContinent_SingleObject.SubContinent_Child_Name);
                Console.WriteLine("\t- People = " + g04_SubContinent.G05_SubContinent_ASingleObject.SubContinent_Child_Name);
                foreach (var g06_Country in g04_SubContinent.G05_CountryObjects)
                {
                    Console.WriteLine("\t\tCountry: " + g06_Country.Country_Name);
                    Console.WriteLine("\t\t- Person = " + g06_Country.G07_Country_SingleObject.Country_Child_Name);
                    Console.WriteLine("\t\t- People = " + g06_Country.G07_Country_ASingleObject.Country_Child_Name);
                    foreach (var g08_Region in g06_Country.G07_RegionObjects)
                    {
                        Console.WriteLine("\t\t\tRegion/State: " + g08_Region.Region_Name);
                        Console.WriteLine("\t\t\t- Person = " + g08_Region.G09_Region_SingleObject.Region_Child_Name);
                        Console.WriteLine("\t\t\t- People = " + g08_Region.G09_Region_ASingleObject.Region_Child_Name);
                        foreach (var g10_City in g08_Region.G09_CityObjects)
                        {
                            Console.WriteLine("\t\t\t\tCity: " + g10_City.City_Name);
                            Console.WriteLine("\t\t\t\t- Person = " + g10_City.G11_City_SingleObject.City_Child_Name);
                            Console.WriteLine("\t\t\t\t- People = " + g10_City.G11_City_ASingleObject.City_Child_Name);
                            foreach (var g12_CityRoad in g10_City.G11_CityRoadObjects)
                            {
                                Console.WriteLine("\t\t\t\t\tRoad: " + g12_CityRoad.CityRoad_Name);
                            }
                        }
                    }
                }
            }
        }