There are the following disadvantages of LINQ over Stored Procedures.
- LINQ query is compiled each and every time while stored procedures re-used the cached execution plan to execute. Hence, LINQ query takes more time in execution as compared to stored procedures.
- LINQ is not the good for writing complex queries as compared to stored procedures.
- LINQ is not a good way for bulk insert and update operations.
- Performance is degraded if you don’t write the LINQ query correctly.
- If you have done some changes in your query, you have to recompile it and redeploy its dll to the server.