static void UpdateLocation()
{
var db = new SafariContext();
var animalToUpdate = db.Animals.FirstOrDefault(animal => animal.Species == "Bear");
animalToUpdate.LocationOfLastSeen = "At Goldilocks' house";
db.SaveChanges();
}
static void UpdateCount()
{
var db = new SafariContext();
var animalToUpdate = db.Animals.FirstOrDefault(animal => animal.Species == "Bear");
animalToUpdate.CountOfTimesSeen = 10;
db.SaveChanges();
}
static void LionsTigersBearsOhMy()
{
var db = new SafariContext();
var lionsTigersAndBears = db.Animals.Where(animal => animal.Species == "Lion" || animal.Species == "Tiger" || animal.Species == "Bear");
var total = lionsTigersAndBears.Sum(animal => animal.CountOfTimesSeen);
Console.WriteLine($"You seen a total of {total} lions, tigers, and bears today! Oh my!");
}
static void AddAllTheAnimals()
{
var db = new SafariContext();
var total = db.Animals.Sum(animal => animal.CountOfTimesSeen);
Console.WriteLine($"You've seen a total of {total} animals today! Woah!");
db.SaveChanges();
}
static void DisplayJungleAnimals()
{
var db = new SafariContext();
var jungleAnimals = db.Animals.Where(animal => animal.LocationOfLastSeen == "Jungle");
foreach (var animal in jungleAnimals)
{
Console.WriteLine($"I saw a {animal.Species} in the Jungle!");
}
db.SaveChanges();
}
static void DeleteDesertAnimals()
{
// 1. Reference the database
var db = new SafariContext();
// 2. Find the thing
var animalsToRemove = db.Animals.FirstOrDefault(animal => animal.LocationOfLastSeen == "Desert");
// 3. Delete the thingdot
db.Animals.Remove(animalsToRemove);
// 4. Save the changes
db.SaveChanges();
}
static void DisplayUserData()
{
// 1. Reference the database
var db = new SafariContext();
// 2. Do the stuff you wanna do
var animalsISaw = db.Animals.Select(animal => animal.Species);
foreach (var animal in animalsISaw)
{
Console.WriteLine($"I a saw a {animal}!");
}
db.SaveChanges();
}