title: Why can't Entity Framework see my Stored Procedure's column information?
body: <p>I have the following stored procedure and when I attempt to Function Import it says my Stored Procedure returns no columns. What am I missing? Any Suggestions? </p>
  
  <p>The Proc: </p>
  
  <pre><code>ALTER PROCEDURE [healthc].[ev_kc_Products_Search]
  (
      @SearchString   VARCHAR(1000)
  )
  AS
  SET NOCOUNT ON
  
      DECLARE @SQL    VARCHAR(max),
          @SQL1   VARCHAR(max),
          @Tag    VARCHAR(5)
  
      CREATE TABLE #T
      (   ID      INT,
          VendorName  VARCHAR(255),
          ItemName        VARCHAR(255),
          Type        VARCHAR(2),
          Sequence        TINYINT
      )
  
  
   SET @SQL = '
  
      INSERT  #T
  
      SELECT  VendorID ID,
          Name VendorName,
          NULL ItemName,
          ''V'' Type,
          0 Sequence
      FROM    tblVendors
      WHERE   '+REPLACE(@SQL1,@Tag,'Name')+'
  
      UNION ALL
  
      BLAH BLAH BLAH'
  
  
   EXEC(@SQL)
  
  
   SELECT ID, VendorName, ItemName, Type FROM #T
  </code></pre>