title: how to discards the scalar value in stored procedure?
body: <p>Please any one tell me how to discards the scalar value in stored procedure?</p>
  
  <p>this is my SP</p>
  
  <pre><code>CREATE PROCEDURE testdata
  AS
  BEGIN
      SET NOCOUNT ON;
      SELECT c.CustomerName,c.CustomerCode, a.Address, a.Email,a.phone,a.ZipCode 
      from Customer c
      join Address a on c.CustomerCode = a.CustomerCode
  END
  GO
  </code></pre>
  
  <p>This is my C# code</p>
  
  <pre><code> CustomerDataEntities enty = new CustomerDataEntities();
          var productEntity = enty.testdata123();
  
      // error foreach statement cannot operate on variables of type int
      foreach (var prd in productEntity) 
      {
  
      }
      return CustomerList;  
  </code></pre>
  
  <p>Thanks.</p>