static void zad2() { var dbContext = new MusicIndustryContext(); var eventsBB = dbContext.Events .Where(x => x.City.Name == "Bielsko-Biala") .Select(x => new { BandName = x.Band.Name, x.Date, CityName = x.City.Name, x.City.Voivodeship }); foreach (var eventBB in eventsBB) { Console.WriteLine(eventBB); } }
static void zad3() { var dbContext = new MusicIndustryContext(); var eventFoals = dbContext.Events .FirstOrDefault(x => x.Band.Name == "Foals"); if (eventFoals != null) { eventFoals.City.Name = "Cracow"; eventFoals.City.Voivodeship = "Malopolskie"; } dbContext.SaveChanges(); }
static void zad1() { var band = new Band { Name = "Foals", Address = new Address { City = new City { Name = "Oxford", Voivodeship = "Oxfordshire" }, Phone = "666431524", Street = "Red Street 16" } }; var newEvent = new Event { Band = band, City = new City { Name = "Bielsko-Biala", Voivodeship = "Silesia" }, Date = DateTime.Now, Tickets = new[] { new Ticket { Price = 30, Type = TicketType.Standard }, new Ticket { Price = 150, Type = TicketType.Vip } } }; var dbContext = new MusicIndustryContext(); dbContext.Events.Add(newEvent); dbContext.SaveChanges(); }