title: The data reader is incompatible with the specified, ...does not have a corresponding column in the data reader with the same name
body: <p>I have a problem with my working project (Using ADO.net Entity Framework) . My database has 2 tables:</p>
  
  <p><a href="https://i.stack.imgur.com/y3NzM.png" rel="nofollow noreferrer">https://i.stack.imgur.com/y3NzM.png</a></p>
  
  <p>Here is my stored procedure:</p>
  
  <pre><code>CREATE PROCEDURE [dbo].[SP_SELECT]
  AS
  BEGIN
      SELECT I.Id, I.Name, C.Name
      FROM ITEM I, CATEGORY C
      WHERE I.CategoryID = C.Id
  END
  </code></pre>
  
  <p>I try to run this stored procedure and I get a message error show that: "The data reader is incompatible with the specified 'TEST2Model.SP_SELECT_Result'. A member of the type, 'Name1', does not have a corresponding column in the data reader with the same name."</p>
  
  <p>I do think it has a problem between the attribute "Name" in ITEM and "Name" in CATEGORY. 
  Please help, thanks!</p>