How is LINQ useful than Stored Procedures?

devquora
devquora

Posted On: Feb 22, 2018

 

LINQ is useful than stored procedures in the following ways:

  • Deployment: In LINQ, deployment becomes easier as everything is compiled into a single DLL. However, in Stored Procedures, an additional script has to be provided.
  • Debugging: since LINQ is a part of .NET languages, queries can be debugged using the visual studio’s debugger. In the case of Stored Procedures, there is difficulty in debugging.
  • Type safety at the compile time, all the queries errors are checked as LINQ is type safe. However, stored procedures are not type-safe, so there is a difficulty in checking the errors.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    LINQ Interview Questions

    What do you understand by LINQ?

    Language Integrated Query is the collection of standard query operators which adds query facilities into .NET framework..

    LINQ Interview Questions

    What are the three main components of LINQ?

    The three main components of LINQ are:Standard Query Operators: These are the extension methods that form the LINQ p..

    LINQ Interview Questions

    Explain what is select clause and where clause in LINQ?

    Select clause: the select clause selects the interesting aspects of the element by performing a projection on the col..