Which is best Between Entity Framework And Stored Procedure

Question

Hi Friends Please tell me Which is best Between Entity Framework And Stored Procedure ? for ERP Application In Asp.net MVC

Kranthi Vardhan Kolluru · Answer

I think it is better to use store procedure instead of EF because using EF some of customized queries we cant do ofcourse there is a chance but as my point of view to approch SQL Server it is good and better to use SP. using sp we can coustamaize our query as we required and we can maintain our database separatly i.e. we can handle the database at our side and just we handover the front end to clients.

Salman · Answer

Hi. One more thing i want to mentioned here is that We can Use Stored Procedure inside EF and for filtering also we can use Linq query simultaneously. To Use Stored procedure is good but use SP in EF is also good and the performance also increases. So my recommendation is to use both. Thanks.