I am working on mvc4. I am stuck with problem where i need to save table data a xml.
my sp code is as belows
Create PROCEDURE [dbo].[usp_GetXMLForClient]
AS
BEGIN
SELECT * from tbl_tablename where lng_clientid=1
for xml path,root('tablename ')
END
It returns xml file but when i try to get this file i am getting error that
function evaluation timed out
Function evaluation disabled because a previous function evaluation timed out. You must continue execution to reenable function evaluation
code i am using to get sp result is
var res = Context.usp_GetXMLForClient();
How can i solve this problem.
Please advise
