What are the advantages of LINQ over Stored Procedures?

 Posted by Tripati_tutu on 1/28/2011 | Category: LINQ Interview questions | Views: 9325 | Points: 40

Below is the three advantages of LINQ over stored procedures.

Debugging - As debug point concern, as LINQ is part of .NET, we can use the visual studio's debugger to debug the queries but it is tough to debug the Stored procedure as it will not support the visual studio debugger.

Deployment - In case of deployment, we need to provide an additional script for stored procedures to execute but in case of LINQ, it will complie into single DLL hence deployment becomes easier.

Type Safety - As LINQ is type safe, the queries errors are type checked at compile time. Better suggest to use LINQ because it helps to encounter an error at the compile time rather than at runtime exception.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response