How to return value from stored procedure

Question

User-1378722245 posted

Hi There,

I am using below Stored procedure call using Webmatix Razor helper class.  below syntax just passing parameter from code behind, How can i return output parameter ? 

var db = Database.Open("ConnectionString");

var SQLSP = "exec dbo.StroredProcedure @0, @1, @2, @3, @4, @5, @6";
db.Execute(SQLSP, int.Parse(MenuID), MenuName, MenuURL, int.Parse(MenuFilterID), MenuFilterValue, int.Parse(MenuParentID), int.Parse(Request.Cookies["UserInfo"]["sSID"]));
Json.Write("Success", Response.Output);

Thanks in advance

Answer 1

User632428103 posted

Hello ramganeshv,

looks at this article, i think you will find your reply : 

return single value : 

https://blogs.msdn.microsoft.com/diego/2012/01/09/stored-procedures-with-output-parameters-using-sqlquery-in-the-dbcontext-api/

return complex type : 

http://www.binaryintellect.net/articles/fbc96859-8a31-4735-baeb-7adcbc521b30.aspx

hope this help

Answer 2

User379720387 posted

var storedprocresult = db.Execute(SQLSP, int.Parse(MenuID), MenuName, MenuURL, int.Parse(MenuFilterID), MenuFilterValue, int.Parse(MenuParentID), int.Parse(Request.Cookies["UserInfo"]["sSID"]));

Proceed as usual