Stored Procedure Output Parameter Kullanımı. I am using database first approach for entity framework in my aspnet project. Output and input parameters please try this source.
Now obviously input parameter means you have to pass something to the stored procedure whereas the output parameter will return something. As a workaround to implement this functionality we can use lookup activity as an alternative. When i add the stored procedure in my mydbcontextedmx file the mydbcontextcs has a function that returns an int probably the output parameter that is.
Rehow to use output parameter from stored procedure check the following link if your going to actually want to bind the parameters as output parameters.
In this example we will query the personaddress table from the adventureworks database but instead of getting back all records we will limit it to just a particular city. Output parameters allow the stored procedure to pass a data value or a cursor variable back to the caller. Or you can make the call and just get the resultset back as i did above. But this shows how everything gets set up from before during and after the call to the stored procedure in the c and how to set the out parameter and get the value out of the stored procedure.