access store procedure and tables from the framework #10078

fdelcarmen created 3 years ago

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

5 Answer(s)

0

ismcagdas created 3 years ago
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.
0

fdelcarmen created 3 years ago

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

Thanks,

Fernando.
0

ismcagdas created 3 years ago
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,
0

fdelcarmen created 3 years ago

Hello,

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

Thanks,

Fernando.
0

ismcagdas created 3 years ago
Support Team

Hi @fdelcarmen

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

Have an answer to this question? Log in and write your answer.