Ejemplo n.º 1
0
        static void Main(string[] args)
        {
            Database.SetInitializer(new MigrateDatabaseToLatestVersion <MountainsContext, Configuration>());
            var context = new MountainsContext();

            Country c = new Country()
            {
                Code = "AB", Name = "Balgaria"
            };
            Mountain m = new Mountain()
            {
                Name = "Stara Planina"
            };

            m.Peaks.Add(new Peak()
            {
                Name = "Musala", Mountain = m
            });
            m.Peaks.Add(new Peak()
            {
                Name = "Vihren", Mountain = m
            });
            c.Mountains.Add(m);

            context.Countries.Add(c);
            context.SaveChanges();
        }
Ejemplo n.º 2
0
        static void Main(string[] args)
        {
            Database.SetInitializer(new MigrateDatabaseToLatestVersion <MountainsContext, Configuration>());

            var context = new MountainsContext();

            var peaks = context.Peaks.Select(p => new
            {
                Name = p.Name
            });

            Console.WriteLine(string.Join(", ", peaks));
        }
Ejemplo n.º 3
0
        private static void Main()
        {
            // pres Enable-Migrations
            //  Database.SetInitializer(new MigrateDatabaseToLatestVersion<StudentSystemDbContext, Configuration>());
            //db.Database.Initialize(true);


            var context = new MountainsContext();

            var bulgaria = new Country {
                Code = "1S", Name = "Bulagria"
            };
            var rila = new Mountain {
                Name = "Rila", Countries = { bulgaria }
            };
            var musala = new Peak {
                Name = "Musala", Mountain = rila, Elevation = 2925
            };

            context.Countries.Add(bulgaria);
            context.Mountains.Add(rila);
            context.Peaks.Add(musala);
            context.SaveChanges();

            var countriesQuery = context.Countries.Select(c =>
                                                          new
            {
                ContryName = c.Name,
                Mountains  = c.Mountains.Select(m =>
                                                new
                {
                    m.Name,
                    m.Peaks
                })
            });


            foreach (var country in countriesQuery)
            {
                Console.WriteLine("Country: " + country.ContryName);
                foreach (var mountain in country.Mountains)
                {
                    Console.WriteLine("     Mountain: " + mountain.Name);
                    foreach (var peak in mountain.Peaks)
                    {
                        Console.WriteLine("\t{0} ({1})", peak.Name, peak.Elevation);
                    }
                }
            }
        }
Ejemplo n.º 4
0
        static void Main(string[] args)
        {
            var context   = new MountainsContext();
            var countries = context.Countries.Count();

            var newCountry = new Country()
            {
                Name = "ZZ Country",
                Code = "ZZ"
            };

            context.Countries.Add(newCountry);
            context.SaveChanges();
            //Console.WriteLine(countries);
        }
 static void Main()
 {
     var context = new MountainsContext();
     var query = context.Mountains.Select(m => new
     {
         m.Name,
         Countries = m.Countries.Select(c => c.Name),
         Peaks = m.Peaks.Select(p => p.Name).ToList()
     });
     foreach (var m in query)
     {
         Console.WriteLine("{0} ; {1} ; {2}",
             m.Name,
             String.Join(", ", m.Countries),
             String.Join(", ", m.Peaks));
     }
 }
Ejemplo n.º 6
0
        static void Main()
        {
            Database.SetInitializer(new MigrateDatabaseToLatestVersion <MountainsContext, MountainsDatabaseMigrationConfiguration>());

            var context = new MountainsContext();
            var query   = context.Mountains.Select(m => new
            {
                m.Name,
                Countries = m.Countries.Select(c => c.Name),
                Peaks     = m.Peaks.Select(p => p.Name)
            });

            foreach (var m in query)
            {
                Console.WriteLine("{0} ; {1} ; {2}", m.Name, String.Join(", ", m.Countries), String.Join(", ", m.Peaks));
            }
        }
Ejemplo n.º 7
0
        static void Main()
        {
            var context = new MountainsContext();
            var query   = context.Mountains.Select(m => new
            {
                m.Name,
                Countries = m.Countries.Select(c => c.Name),
                Peaks     = m.Peaks.Select(p => p.Name).ToList()
            });

            foreach (var m in query)
            {
                Console.WriteLine("{0} ; {1} ; {2}",
                                  m.Name,
                                  String.Join(", ", m.Countries),
                                  String.Join(", ", m.Peaks));
            }
        }
        private static void Main()
        {
            // pres Enable-Migrations
            //  Database.SetInitializer(new MigrateDatabaseToLatestVersion<StudentSystemDbContext, Configuration>());
            //db.Database.Initialize(true);

            var context = new MountainsContext();

            var bulgaria = new Country { Code = "1S", Name = "Bulagria" };
            var rila = new Mountain { Name = "Rila", Countries = { bulgaria } };
            var musala = new Peak { Name = "Musala", Mountain = rila, Elevation = 2925 };

            context.Countries.Add(bulgaria);
            context.Mountains.Add(rila);
            context.Peaks.Add(musala);
            context.SaveChanges();

            var countriesQuery = context.Countries.Select(c =>
                                new
                                {
                                    ContryName = c.Name,
                                    Mountains = c.Mountains.Select(m =>
                                        new
                                        {
                                            m.Name,
                                            m.Peaks
                                        })
                                });

            foreach (var country in countriesQuery)
            {
                Console.WriteLine("Country: " + country.ContryName);
                foreach (var mountain in country.Mountains)
                {
                    Console.WriteLine("     Mountain: " + mountain.Name);
                    foreach (var peak in mountain.Peaks)
                    {
                        Console.WriteLine("\t{0} ({1})", peak.Name, peak.Elevation);
                    }
                }
            }
        }
 private static void AddCountryToDb(MountainsContext context, MountainDTO mountainDTO)
 {
     if(mountainDTO.MountainName == null)
     {
         throw new Exception("Mountain name is required");
     }
     var m = new Mountain() { Name = mountainDTO.MountainName };
     foreach (var peak in mountainDTO.Peaks)
     {
         if(peak.PeakName == null)
         {
             throw new Exception("Peak name is required");
         }
         if(peak.Elevation == null)
         {
             throw new Exception("Peak elevation is required");
         }
         var peakToDb = new Peak()
         {
             Name = peak.PeakName,
             Elevation = peak.Elevation.GetValueOrDefault()
         };
         m.Peaks.Add(peakToDb);
     }
     foreach (var countryName in mountainDTO.Countries)
     {
         var country = context.Countries.FirstOrDefault(c => c.Name == countryName);
         if (country == null)
         {
             country = new Country()
             {
                 Code = countryName.ToUpper().Substring(0, 2),
                 Name = countryName
             };
         }
         country.Mountains.Add(m);
         context.Countries.Add(country);
     }
     context.Mountains.Add(m);
 }
        static void Main()
        {
            var context = new MountainsContext();
            var json = File.ReadAllText(@"../../mountains.json");
            JavaScriptSerializer ser = new JavaScriptSerializer();
            var mountains = ser.Deserialize<MountainDTO[]>(json);

            foreach (var mountainDTO in mountains)
            {
                try
                {
                    AddCountryToDb(context, mountainDTO);
                    Console.WriteLine("Mountain {0} imported", mountainDTO.MountainName);
                }
                catch(Exception ex)
                {
                    Console.WriteLine("Error: {0}", ex.Message);
                }

            }
            context.SaveChanges();
        }
Ejemplo n.º 11
0
        static void Main(string[] args)
        {
            Database.SetInitializer(new MountainsMigrationStrategy());

            //Country c = new Country() {Code = "AB" , Name = "Absurdistan"};
            //Mountain m = new Mountain() {Name = "Absurditan Hills" };
            //m.Peaks.Add(new Peak() {Name = "Great Peak", Mountain = m});
            //m.Peaks.Add(new Peak() {Name = "Small Peak", Mountain = m});
            //c.Mountains.Add(m);

            //var context = new MountainsContext();
            //context.Countries.Add(c);
            //context.SaveChanges();

            var context = new MountainsContext();
            var countriesQuery = context.Countries.Select(c => new
            {
                CountryName = c.Name,
                Mountains = c.Mountains.Select(m => new
                {
                    m.Name,
                    m.Peaks
                })
            });

            foreach (var country in countriesQuery)
            {
                Console.WriteLine("Country: " + country.CountryName);
                foreach (var mountain in country.Mountains)
                {
                    Console.WriteLine("  Mountain: " + mountain.Name);
                    foreach (var peak in mountain.Peaks)
                    {
                        Console.WriteLine("\t{0} ({1})", peak.Name, peak.Elevation);
                    }
                }
            }
        }