Base solution for your next web application
Open Closed

Integrating SP in Module Zero #319


User avatar
0
thobiasxp created

Hi

I am using some complex storeed procedure(SP) in my application for generating charts. now i am using module zero for application development...so i needed to use that SP's to module zero project...how can i integrate the store procedures in my module zero application....kindly give a guidance...make reply ASAp.

Thanks


3 Answer(s)
  • User Avatar
    0
    hikalkan created
    Support Team

    Hi,

    See document for custom repositories: <a class="postlink" href="http://www.aspnetboilerplate.com/Pages/Documents/EntityFramework-Integration#DocCustomRepositoryMethods">http://www.aspnetboilerplate.com/Pages/ ... oryMethods</a> You can create such a repository and create a method and call your SP inside it. In this method you can access to the DbContext directly (as Context). If you know how to work with SPs and EF, you can write it easily.

  • User Avatar
    0
    ashgadala created

    I have asked this question here 2723 what can't we re use the default repo?

  • User Avatar
    0
    alper created
    Support Team

    hi,

    see this article about how to run Stored Procedures https://aspnetboilerplate.com/Pages/Documents/Articles/Using-Stored-Procedures,-User-Defined-Functions-and-Views/index.html