Click here to Skip to main content
15,850,298 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi all,

I wanted to Call Stored Procedure using Entity Framework,SP is using Pivot and #Temp table and returning distinct and different columns run time.

Now the problem here is, when I am adding SP as using Function Import, and clicking on Get Column Information it is giving me "The selected stored procedure returns no columns."

Thanks in Advance
Posted
Comments
joginder-banger 13-Feb-14 12:44pm    
share your coding parts for better understand what's you try???????????

This[^] should help.

[Please accept/up-vote answers or solutions that work for you to encourage others]
 
Share this answer
 
Comments
GauravThorat 13-Feb-14 23:57pm    
I have try this in SP :
SET FMTONLY OFF
but did not worked for me
I have set all Adhoc query Options
and
called the required sp in another sp
like

SQL
SELECT *
FROM OPENQUERY([Server],
      'SET NOCOUNT ON; EXEC [DB].[dbo].SP ''33''')


Now I wanted to get pass the 33 which through parameter like

SQL
SELECT *
FROM OPENQUERY([Server],
      'SET NOCOUNT ON; EXEC [DB].[dbo].SP '''+@Param1+'''')


but it is giving me error

Thanks All
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900