static void Main(string[] args) { var db = new SafariContext(); db.SaveChanges(); var data = db.Animals .AsEnumerable() .Where(anim => anim.CountSeen > 0) .First(); Console.WriteLine("Animals You have seen atleast once!"); Console.WriteLine(data.Species); AnimalModel.Animal updateRecord = ( from x in db.Animals where x.Id == 4 select x ).First(); updateRecord.CountSeen += 1; updateRecord.LocationOfLastSeen = "In a tree somewhere"; db.SaveChanges(); Console.WriteLine($"Count Seen: {updateRecord.CountSeen}"); Console.WriteLine($"Location of last seen: {updateRecord.LocationOfLastSeen}"); Console.ReadLine(); }
static IEnumerable <AnimalModel.Animal> Read() { var db = new SafariContext(); Console.WriteLine(db.Animals .Where(anim => anim.Species == "Unicorn") .Take(5)); return(null); }