On Entity Framework days, doing an MVC project using Stored Procedure is a good way? I've always heard this: If you choose EF, it does not make sense to use SP, but I've heard people say that this is not necessarily an absolute truth. Then comes the question: SP X EF gives to use both worlds or not? It is not a broad question and it does not receive many opinions. The answer would be whether to use the two or not in an MVC architecture.
Stored Proc X Entity - Is it a good decision?
2
asked by anonymous 29.06.2015 / 15:06
1 answer
4
On Entity Framework days, doing an MVC project using Stored Procedure is a good way?
No.
The intent of the Entity Framework for development is to save programming effort by modeling the database as a tailor, adjusting it perfectly to the application code, with best possible database normalization practices. With this, it is expected that queries will also be optimized by following a natural pattern of bank design.By putting Stored Procedures , you would be wasting all the work that Framework does for you. Unless much you need to pay special attention to security, after it's done , it may be interesting to have the system perform access to Stored Procedures < in>. I explain all this in this answer .
29.06.2015 / 16:19