Tell us about the advantages of LINQ over Stored Procedure?

 Posted by vishalneeraj-24503 on 9/29/2014 | Category: LINQ Interview questions | Views: 619 | Points: 40

Debugging – LINQ supports .Net debugger,so we can easily debug a LINQ query using .Net debugger but it is not supported by SQL stored procedure so it is hard to debug the stored procedure.
Deployment – To deploy stored procedure it is necessary to write one more script to run them,while LINQ will complie by a single DLL statement and so the deployment will be simple.
Type Safety - As LINQ supports type safety so errors can be type checked in LINQ queries in compile time.
It is better to use LINQ as it enable us to identify the errors while compilation rather than runtime execution.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response