Why can't Entity Framework see my Stored Procedure's column information?
entity-framework, entity-framework-4, sql-server, stored-procedures, t-sql
Solution
Try adding this line to the beginning of your stored procedure:
SET FMTONLY OFF
You can remove this after you have finished importing.
Problem
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? The Proc: ``` 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 ```