public void DbImport(out List <GameDevEssence> gameDevEsList, GameDevEntities db) { gameDevEsList = new List <GameDevEssence>(); int k = 0; foreach (var obj in db.GameIndustry) { GameDevEssence gameDevEssence = new GameDevEssence(); gameDevEssence.GameIndustry = obj; gameDevEsList.Add(gameDevEssence); k++; } for (int i = 0; i < k; i++) { foreach (var obj in db.Games) { if (obj.Id == gameDevEsList[i].GameIndustry.GameId) { gameDevEsList[i].Games = obj; break; } } foreach (var obj in db.Companies) { if (obj.Id == gameDevEsList[i].GameIndustry.CompanyId) { gameDevEsList[i].Companies = obj; break; } } foreach (var obj in db.Publishers) { if (obj.Id == gameDevEsList[i].GameIndustry.PublisherId) { gameDevEsList[i].Publishers = obj; break; } } foreach (var obj in db.Developers) { if (obj.Id == gameDevEsList[i].GameIndustry.DeveloperId) { gameDevEsList[i].Developers = obj; break; } } } }
protected override void OnStart(string[] args) { try { using (GameDevEntities db = new GameDevEntities()) { List <GameDevEssence> gameDevEsList = new List <GameDevEssence>(); DatabaseOperations dataAccess = new DatabaseOperations(); dataAccess.DbImport(out gameDevEsList, db); List <string> data = dataAccess.DbConvert(gameDevEsList); XmlDbSerializer xmlDbSerializer = new XmlDbSerializer(); xmlDbSerializer.XmlSerialize <List <string> >($"G:/Work/GameIndustryInfo.xml", data); } } catch (Exception ex) { using (StreamWriter sw = new StreamWriter("errors.txt")) { sw.WriteLine(ex.Message); } } }