static void Main() { //Console.WriteLine(countriesCount); Database.SetInitializer(new MountainsMigrationsStrategy()); var context = new MountainsContext(); var countriesCount = context.Countries.Count(); Country c1 = new Country() { CountryCode = "AB", CountryName = "Absurdistan" }; Mountain m1 = new Mountain() { Name = "Absurdistan Hills" }; m1.Peaks.Add(new Peak() { Name = "Great Peak", Mountain = m1 }); m1.Peaks.Add(new Peak() { Name = "Small Peak", Mountain = m1 }); c1.Mountains.Add(m1); context.Countries.Add(c1); context.SaveChanges(); var mountains = context.Mountains .Select(mo => new { mo.Name, Countries = mo.Countries.Select(co => co.CountryName), Peaks = mo.Peaks.Select(p => p.Name) }).ToList(); foreach (var mountain in mountains) { // Console.WriteLine("Mname: {0}; Countries: {1}; Peaks :{2}", mountain.Name, string.Join(", ",mountain.Countries), string.Join(", ", mountain.Peaks)); } var countries = context.Countries .Select(c => new { c.CountryName, Mountains = c.Mountains, Peaks = c.Mountains.Select(m => m.Peaks) }); foreach (var country in countries) { Console.WriteLine("Country: {0}", country.CountryName); foreach (var m in country.Mountains) { Console.WriteLine(" Mountain: {0}", m.Name); foreach (var peak in m.Peaks) { Console.WriteLine("\t{0} ({1})", peak.Name, peak.Elevation); } } } }
protected override void Seed(MountainsContext context) { var bulgaria = new Country { CountryCode = "BG", CountryName = "Bulgaria" }; context.Countries.Add(bulgaria); var germany = new Country { CountryCode = "DE", CountryName = "Germany" }; context.Countries.Add(germany); var rila = new Mountain { Name = "Rila", Countries = { bulgaria } }; context.Mountains.Add(rila); var pirin = new Mountain { Name = "Pirin", Countries = { bulgaria } }; context.Mountains.Add(pirin); var rhodopes = new Mountain { Name = "Rhodopes", Countries = { bulgaria } }; context.Mountains.Add(rhodopes); var musala = new Peak { Name = "Musala", Mountain = rila, Elevation = 2925 }; context.Peaks.Add(musala); var malyovitsa = new Peak { Name = "Malyovitsa", Mountain = rila, Elevation = 2729 }; context.Peaks.Add(malyovitsa); var vihren = new Peak { Name = "Vihren", Mountain = pirin, Elevation = 2914 }; context.Peaks.Add(vihren); }