在Entity Framework中使用存储的查询

CREATE PROCEDURE GetEmployeesByCity
    @City NVARCHAR(50)
AS
BEGIN
    SELECT * FROM Employees WHERE City = @City
END

public class MyContext : DbContext
{
    public DbSet<Employee> Employees { get; set; }

    public IEnumerable<Employee> GetEmployeesByCity(string city)
    {
        return this.Database.SqlQuery<Employee>("GetEmployeesByCity @City", new SqlParameter("@City", city));
    }
}

using (var context = new MyContext())
{
    var employees = context.GetEmployeesByCity("New York");
    foreach (var employee in employees)
    {
        Console.WriteLine(employee.Name);
    }
}