static void LtbOhMy() { var db = new SafariContext(); var Ltb = db.Safaris.Where(Safari => Safari.Species == "Lion" || Safari.Species == " Tiger" || Safari.Species == "Bear").Sum(safari => safari.CountOfTimesSeen); System.Console.WriteLine(Ltb); }
static void UsingSum() { var db = new SafariContext(); var sumCountOfTimesSeen = db.Safaris.Sum(Safaris => Safaris.CountOfTimesSeen); Console.WriteLine(sumCountOfTimesSeen); }
static void RemoveTheDesert() { var db = new SafariContext(); var removeDessert = db.Safaris.Where(Safari => Safari.LocationOfLastSeen == "Dessert"); db.Safaris.RemoveRange(removeDessert); db.SaveChanges(); }
static void UpdateData() { var db = new SafariContext(); var updateSpecies = db.Safaris.FirstOrDefault(Safari => Safari.Species == "Stephen Gacio"); updateSpecies.CountOfTimesSeen = 50; updateSpecies.LocationOfLastSeen = "SDG"; db.SaveChanges(); }
//display animals seen in Safari, not Jungle... Sorry. static void ReadMoreData() { var db = new SafariContext(); var AllTheJung = db.Safaris .Where(Safari => Safari.LocationOfLastSeen == "Safari") .Select(Safari => Safari.Species); System.Console.WriteLine(AllTheJung.FirstOrDefault()); }
static void ReadData() { var db = new SafariContext(); var AllTheSpecies = db.Safaris.Select(safari => safari.Species); //thanks Mark for showing Stephen this, he showed me. foreach (var species in AllTheSpecies) { Console.WriteLine(species); } }
static void SeedData() { var db = new SafariContext(); var favoriteAdventure = new Safari { Species = "Stephen Gacio", CountOfTimesSeen = 123123, LocationOfLastSeen = "Outside of his natural environment" }; var favoriteAdventure2 = new Safari { Species = "Lion", CountOfTimesSeen = 2, LocationOfLastSeen = "Safari" }; var favoriteAdventure3 = new Safari { Species = "Cougar", CountOfTimesSeen = 400, LocationOfLastSeen = "Starbucks " }; var favoriteAdventure4 = new Safari { Species = "Lion", CountOfTimesSeen = 420, LocationOfLastSeen = "walmart" }; var favoriteAdventure5 = new Safari { Species = "Tiger", CountOfTimesSeen = 123123, LocationOfLastSeen = "My Driveway" }; var favoriteAdventure6 = new Safari { Species = "Bear", CountOfTimesSeen = 1, LocationOfLastSeen = "Desert" }; // db.Safaris.Add(favoriteAdventure); // db.Safaris.Add(favoriteAdventure2); // db.Safaris.Add(favoriteAdventure3); // db.Safaris.Add(favoriteAdventure4); // db.Safaris.Add(favoriteAdventure5); // db.Safaris.Add(favoriteAdventure6); db.SaveChanges(); }