Question: what is difference between stored procedure and linq?
Answer: LINQ query is compiled each and every time while stored procedures re-used the cached execution plan to execute. Hence, a LINQ query takes more time in execution as compared to stored procedures. ... If you have done some changes in your query, you have to recompile it and redeploy its DLLs to the server.