Click here to Skip to main content
15,908,843 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a stored procedure

SQL
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE proc_Report_Dynamicquerybuilding 
 @SQLQuery AS NVARCHAR(max)
AS
BEGIN
SET NOCOUNT ON;
EXECUTE(@SQLQuery)
END
GO

it executes the query i am sending but when i an using it in ADO.NET Entity Data Model
i am unable to assign the return type for this function as it gets created dynamically at run time and because of that im not getting the output of the query
please help me with this its very Urgent
Posted
Updated 7-Aug-12 22:40pm
v2
Comments
StianSandberg 8-Aug-12 3:47am    
why on earth would you do something like this?
jyoti mahalik 8-Aug-12 3:52am    
because i want to execute the query at runtime
i have a page to build the query dynamically
and then see the result of that
i have the query ready with me but as its the query build by user it can be anything on earth
so not able to get the return type for that

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