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(); }