static void CountTheAnimals() { var db = new SafariContext(); var animalCount = db.Trip.Sum(views => views.NumberOfTimesSeen); Console.WriteLine(animalCount); }
// static void animalsSeenUpdate() // { // var db = new SafariContext(); // var updateTheseKids = db.Trip.FirstOrDefault(vacation => vacation.species == "Albert Strange"); // if (updateTheseKids != null) // { // updateTheseKids.NumberOfTimesSeen = 7; // updateTheseKids.LocationLastSeen = "Gym"; // db.SaveChanges(); // } // var alberts = db.Trip.Where(tr => tr.species == "Albert Strange"); // foreach (var albert in alberts) // { // albert.LocationLastSeen = "dessert"; // } // db.SaveChanges(); // } static void MarkDoesntLikeTheDessert() { var db = new SafariContext(); var deleteTheDessert = db.Trip.Where(area => area.LocationLastSeen == "dessert"); db.Trip.RemoveRange(deleteTheDessert); db.SaveChanges(); }
static void whereISeeYou() { var db = new SafariContext(); var whereAt = db.Trip.Where(where => where.LocationLastSeen == "jungle"); foreach (var animal in whereAt) { Console.WriteLine(animal.species); } }
static void LionsTigersAndBearsOhMy() { var db = new SafariContext(); var lions = db.Trip.Where(thing => thing.species == "lion" || thing.species == "tiger" || thing.species == "bear").Sum(thing => thing.NumberOfTimesSeen); // var Tigers = db.Trip.Where(thing => thing.species == "tiger").Sum(thing => thing.NumberOfTimesSeen); // var Bears = db.Trip.Where(thing => thing.species == "bear").Sum(thing => thing.NumberOfTimesSeen); // var total = lions + Tigers + Bears; Console.WriteLine(lions); }
// static void SeedData() // { // var db = new SafariContext(); // var favoriteTrip = new Safari // { // species = "lion", // NumberOfTimesSeen = 3, // LocationLastSeen = "jungle" // }; // var favoriteTrip1 = new Safari // { // species = "tiger", // NumberOfTimesSeen = 2, // LocationLastSeen = "jungle" // }; // var favoriteTrip2 = new Safari // { // species = "bear", // NumberOfTimesSeen = 2, // LocationLastSeen = "forest" // }; // var favoriteTrip3 = new Safari // { // species = "Mark Dewey", // NumberOfTimesSeen = 2, // LocationLastSeen = "under water but above ground" // }; // var favoriteTrip4 = new Safari // { // species = "Albert Strange", // NumberOfTimesSeen = 2, // LocationLastSeen = "Dessert" // }; // db.Trip.Add(favoriteTrip); // db.Trip.Add(favoriteTrip1); // db.Trip.Add(favoriteTrip2); // db.Trip.Add(favoriteTrip3); // db.Trip.Add(favoriteTrip4); // db.SaveChanges(); // } static void animalsSeen() { var db = new SafariContext(); var whichAnimals = db.Trip.Select(timeOut => timeOut.species); // Console.WriteLine($"{whichAnimals}"); foreach (var animal in whichAnimals) { Console.WriteLine(animal); } Console.WriteLine("its the animals"); }