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 Database object—SqlQuery and 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
ENDWe just need a class that matches the results of our stored procedure, as shown in the following code:
public class CompanyInfo
{
public int CompanyId { get; set; }
public string CompanyName { get; set; }
}The same class looks as follows in VB.NET:
Public Class CompanyInfo
Property CompanyId() As Integer
Property...