public MappingCollectionTest() { testDB = new DAL("MappingCollectionTest" + ".cruise", true); Random rand = new Random(0); List<CuttingUnitDO> units = new List<CuttingUnitDO>(); for (int i = 1; i <= 10; i++) { CuttingUnitDO cu = new CuttingUnitDO(testDB); cu.Code = i.ToString(); cu.Area = rand.Next(9) + 1.0f; cu.Save(); units.Add(cu); } List<StratumDO> strata = new List<StratumDO>(); for (int i = 0; i <= 10; i++) { StratumDO st = new StratumDO(testDB); st.Code = i.ToString(); st.Method = "something"; st.Save(); strata.Add(st); } foreach (CuttingUnitDO cu in units) { for (int i = 0; i < cu.Area; i++) { CuttingUnitStratumDO cust = new CuttingUnitStratumDO(testDB); cust.CuttingUnit_CN = cu.CuttingUnit_CN; cust.Stratum_CN = strata[i].Stratum_CN; cust.Save(); } } testDB.FlushCache(); }