SQL Access / Stored Procedure Calls from the framework #8339

twopenguinsstudios created 4 years ago

What is the best practice for the case when we want to make a direct database call, like a stored procedure. Typically with Entity you can get at this from the db context but the db context is extracted a bit away from us with AspNetZero. We would want to utilize the frameworks connection management and transaction management if possible rather than just instantiating a sql connection outside the framework.

Any suggestions?

Thanks

2 Answer(s)

1

maliming created 4 years ago
Support Team

Have you see this article? https://aspnetboilerplate.com/Pages/Documents/Articles/Using-Stored-Procedures,-User-Defined-Functions-and-Views/index.html
0

twopenguinsstudios created 4 years ago

Thanks! that was exactly what I was looking for.

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