The process of working with stored procedures in Entity Framework is similar to the process of working with views. We will use the same two methods we just saw on the
ExecuteSqlCommand. In order to read a number of rows from a stored procedure, we simply need a class that we will use to materialize all the rows of retrieved data into a collection of instances of this class. For example, to read the data from the stored procedure, consider this query:
CREATE PROCEDURE [dbo].[SelectCompanies] @dateAdded as DateTime AS BEGIN SELECT CompanyId, CompanyName FROM Companies WHERE DateAdded > @dateAdded END
We just need a class that matches the results of our stored procedure, as shown in the following ...