You must Sign In to post a response.
  • Category: ASP.NET

    Which is the best for MVC app Stored Procedure or Linq ?

    Hi I am creating E-commerce Portal in MVC ?

    which is best Stored Procedure OR LINQ
  • #765525
    Go for LINQ over stored procedure because you can debug and improve LINQ code, please go through these links where you can find advantages and disadvantages of both with performance comparison:

    Hope it helps.!

  • #765536
    Hi Ajit,

    I would suggest you to go with stored procedure .
    Please find below comparisons between sp and linq which will help you to make decision.

    A brief comparison of LINQ and Stored Procedure
    Stored procedures are faster as compared to LINQ query since they have a predictable execution plan and can take the full advantage of SQL features. Hence, when a stored procedure is being executed next time, the database used the cached execution plan to execute that stored procedure.
    LINQ has full type checking at compile-time and Intellisense support in Visual Studio as compared to stored procedure. This powerful feature helps you to avoid run-time errors.
    LINQ allows debugging through .NET debugger as compared to stored procedure.
    LINQ also supports various .NET framework features like multi –threading as compared to stored procedures.
    LINQ provides the uniform programming model (means common query syntax) to query the multiple databases while you need to re-write the stored procedure for different databases.
    Stored procedure is a best way for writing complex queries as compared to LINQ.
    Deploying LINQ based application is much easy and simple as compared to stored procedures based. Since in case of stored procedures, you need to provide a SQL script for deployment but in case of LINQ everything gets complied into the DLLs. Hence you need to deploy only DLLs.
    Limitation 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 DLLs to the server.

  • Sign In to post your comments