private static void ImportStars() { XDocument documentXml = XDocument.Load(Constants.StarsPath); IEnumerable <XElement> starsNode = documentXml.XPathSelectElements("Stars/Star"); using (PlanetHuntersContext context = new PlanetHuntersContext()) { foreach (XElement starNode in starsNode) { string starName = starNode.Element("Name")?.Value; string starTemperatureAsString = starNode.Element("Temperature")?.Value; string starSystemName = starNode.Element("StarSystem")?.Value; if (starName == null || starName.Length > 255) { Console.WriteLine(Messages.Error); continue; } if (starTemperatureAsString == null) { Console.WriteLine(Messages.Error); continue; } int starTemperature = int.Parse(starTemperatureAsString); if (starTemperature < 2400) { Console.WriteLine(Messages.Error); continue; } Star starEntity = new Star() { Name = starName, Temperature = starTemperature }; if (HelperMethods.IsStarSystemExisting(context, starSystemName)) { starEntity.HostStarSystem = HelperMethods.GetStarSystem(context, starSystemName); } else { if (starSystemName == null || starSystemName.Length > 255) { Console.WriteLine(Messages.Error); continue; } StarSystem starSystemEntity = new StarSystem() { Name = starSystemName }; HelperMethods.AddStarSystemToDatabase(context, starSystemEntity); starEntity.HostStarSystem = starSystemEntity; } HelperMethods.AddStarToDatabase(context, starEntity); } } }