I am using entity framework with a stored procedure, in which I am generating query dynamically and executing that query. The stored proc query looks like:
Begin
DECLARE @Query nvarchar(MAX)
SET @Query = 'SELECT e.id, e.name, e.add, e.phno from employee'
EXEC sp_executesql @Query
End
In above sql code you can see that i am executing '@Query'
variable, and that variable value can be changed dynamically.
I am able to add my stored proc in my edmx
file. and then I go to model browser and say Add function import
and try to Get column information
it does not show anything. but when I execute my stored proc at server it returns all columns with values. Why i am not getting column information at model browser?