private static void InsertData()
{
var p1 = new Pet {
Name = "Moose", Animal = "Chocolate Lab"
};
var p2 = new Pet {
Name = "Yoyo", Animal = "Cat"
};
var p3 = new Pet {
Name = "Rosie", Animal = "Dog"
};
var p4 = new Pet {
Name = "Lab Rat", Animal = "Cat"
};
var db = new SimpleDb();
db.Pets.Add(p1);
db.Pets.Add(p2);
db.Pets.Add(p3);
db.Pets.Add(p4);
db.SaveChanges(); //Adds the data to the database
Console.WriteLine("Data Added");
}
static void Main(string[] args)
{
//InsertData();
var db = new SimpleDb();
db.Database.Log = Console.WriteLine;
//var cats = from p in db.Pets
// where p.Animal == "Cat"
// select p;
//var cats = db.Pets.Where(p => p.Animal == "Cat");
var allPets = from p in db.Pets
orderby p.Name
select p;
var cats = from p in allPets
where p.Animal == "Cat" && p.Id > 1
select p;
var downloadedCats = cats.ToList();
foreach (var cat in downloadedCats)
{
Console.WriteLine($"{cat.Name}");
}
foreach (var cat in downloadedCats)
{
Console.WriteLine($"{cat.Name}");
}
Console.WriteLine("All done");
//var moose = db.Pets.Find(1); //Look up by ID
var meeses = from p in db.Pets
where p.Animal == "Chocolate Lab"
select p;
var moose = meeses.FirstOrDefault(); //null if there is no moose
//var moose = meeses.First(); //Exception if there is no moose
}
