static void Main()
{
var xmlDoc = XDocument.Load(@"..\..\rivers.xml");
var riverNodes = xmlDoc.XPathSelectElements("/rivers/river");
var context = new GeographyEntities();
foreach (var riverNode in riverNodes)
{
// Parse the river properties
var river = new River
{
RiverName = riverNode.Descendants("name").First().Value,
Length = int.Parse(riverNode.Descendants("length").First().Value),
Outflow = riverNode.Descendants("outflow").First().Value
};
var drainageArea = riverNode.Descendants("drainage-area").FirstOrDefault();
if (drainageArea != null)
{
river.DrainageArea = int.Parse(drainageArea.Value);
}
var averageDischarge = riverNode.Descendants("average-discharge").FirstOrDefault();
if (averageDischarge != null)
{
river.AverageDischarge = int.Parse(averageDischarge.Value);
}
// Load the countries for each river
var countryNodes = riverNode.XPathSelectElements("countries/country");
foreach (var countryNode in countryNodes)
{
var country = context.Countries.
FirstOrDefault(c => c.CountryName == countryNode.Value);
if (country == null)
{
throw new Exception("Can not find country: " + countryNode.Value);
}
river.Countries.Add(country);
}
// Save the river in the database
context.Rivers.Add(river);
context.SaveChanges();
}
Console.WriteLine("Rivers imported from rivers.xml");
}
