title: Stored procedure with Entity Framework get only one column
body: <p>I want to get specific column of the table but I get this error</p>
  
  <blockquote>
    <p>The data reader is incompatible with the specified 'NewsDatabaseModel.News'. A member of the type, 'NewsSubject', does not have a corresponding column in the data reader with the same name.</p>
  </blockquote>
  
  <p>I don't want to use stored procedure via the model I just want to call it.</p>
  
  <p>Here is my code</p>
  
  <pre><code>var NewsList = db.Database.SqlQuery&lt;News_Application.News&gt;("[dbo].[GetAllNews]").ToList();
  return View("NewsList");
  </code></pre>
  
  <p>SQL: </p>
  
  <pre><code>CREATE PROCEDURE GetAllNews
  AS
  BEGIN
      SELECT NewsId, NewsTitle  
      FROM News
  END
  </code></pre>