private static void QueryPetsByType(string type)
{
using var petContext = new PetContext();
List <Pet> pets = petContext.Pets
.FromSqlRaw("EXEC GetPetsByType @Type={0};", type)
.ToList();
foreach (var pet in pets)
{
Console.WriteLine($"Name: {pet.Name}");
}
}
private static void Setup()
{
using var petContext = new PetContext();
petContext.Database.EnsureCreated();
petContext.Database.ExecuteSqlRaw("DELETE FROM Pets WHERE 1 = 1");
petContext.Pets.Add(new Pet {
Name = "Grumpy Cat", Type = "Cat"
});
petContext.Pets.Add(new Pet {
Name = "Smelly Cat", Type = "Cat"
});
petContext.Pets.Add(new Pet {
Name = "Lassie", Type = "Dog"
});
petContext.SaveChanges();
}
