Base solution for your next web application
Open Closed

access store procedure and tables from the framework #10078

User avatar
0
fdelcarmen created

Hello

i want to create a custom repository in verssion to access store procedure and tables from the framework.

i am using the following article: https://aspnetboilerplate.com/Pages/Documents/Articles/Using-Stored-Procedures,-User-Defined-Functions-and-Views/index.html

But , i get an error in my project. Please see attached image.

Thanks

Go to accepted answer
5 Answer(s)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi,

    You can take a look at https://www.entityframeworktutorial.net/efcore/working-with-stored-procedure-in-ef-core.aspx. Executing a Stored procedure n AspNet Zero is similar to you do in any EF Core project.

    Please let us know if you face any problems.

  • User Avatar
    0
    fdelcarmen created

    I have installed Microsoft.EntityFrameworkCore.Relational nuget package, but i get the same error.

    Thanks,

    Fernando.

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @fdelcarmen

    Is it possible to share your solution or a reproduction solution to [email protected] ? We can fix this for you.

    Thanks,

  • User Avatar
    0
    fdelcarmen created

    Hello,

    This is a more specific error from the test. it is about the capacity to use store procedure from framework.

    Thanks,

    Fernando.

  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @fdelcarmen

    Unit tests are using SQLite database and it doesn't support Stored Procedures as far as I know.

Assignee
No one
Labels
None yet