HOW LINQ IS BENEFICIAL THAN STORED PROCEDURES?

Awadhendra Tiwari

Total Post:510

Points:2550
Posted by  Awadhendra Tiwari
C# 
C#
 1867  View(s)
Ratings:
Rate this:
  1. Awadhendra Tiwari

    Post:510

    Points:2550
    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, you 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!

Answer

NEWSLETTER

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