HOW LINQ IS BENEFICIAL THAN STORED PROCEDURES?

Anupam Mishra

Total Post:23

Points:115
Posted by  Anupam Mishra
 570  View(s)
Ratings:
Rate this:
  1. Anupam Mishra

    Post:23

    Points:115
    How LINQ is beneficial than Stored Procedures?

    How LINQ is beneficial than Stored Procedures?

    There are couple of advantage of LINQ over stored procedures:

    1. Debugging - It is really very hard to debug the Stored procedure but as LINQ is part of .NET, we can use visual studio's debugger to debug the queries.

    2. Deployment - With stored procedures, we need to provide an additional script for stored procedures but with LINQ everything gets complied into single DLL hence deployment becomes easy.

    3. Type Safety - LINQ is type safe, so queries errors are type checked at compile time. It is really good to encounter an error when compiling rather than runtime exception!

      Modified On Mar-28-2016 11:59:05 PM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!