Base solution for your next web application
Open Closed

Stored Procedure Call From AppService #3208


User avatar
0
pankajmathur created

Hi,

Can you please provide a sample example showing how to call a stored procedure from my appService.

Regards, Mahendra


2 Answer(s)
  • User Avatar
    0
    pankajmathur created

    The procedure has some input and some output parameter. The stored procedure is not related to an entity. It's a generic stored procedure that I need to call and get the value in Output parameter.

    Please help urgently....

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi,

    In order to do that, first you need to create a custom repository, see <a class="postlink" href="http://aspnetboilerplate.com/Pages/Documents/Repositories#custom-repositories">http://aspnetboilerplate.com/Pages/Docu ... positories</a>. Then in your custom repository you can access the DbContext and you can call SP, View or Functions just like you do in a regular Entity Framework project.

    Thanks.