title: MVC4 and Entity Framework 5 stored procedures
body: <p>Hi Im trying to access a database table in my mvc4 application using a stored procedure and Entity Framework 5. 
  I created a FormValueModel.edmx file and imported the User Table and the GetUser Stored Procedure</p>
  
  <p>Here is the code for the GetUser Stored Procedure</p>
  
  <pre><code>SELECT 
      *
  FROM
      [User].[User]
  Where
      @UserName = UserName 
      AND @UserPassword = UserPassword
      AND Active = 1
  </code></pre>
  
  <p>Here is the code in my Controller to access the stored procedure</p>
  
  <pre><code>using (var db = new FormValueEntities())
  {
      string userName ="TestUser"
      string password = "Password"
  
      var query = db.GetUser(userName, password);
  
  }   
  </code></pre>
  
  <p>Why cant I access the table by using query.UserName or query.UserPassword ect.</p>
  
  <p>Thanks in advance</p>