Home > DeveloperSection > Interviews > How LINQ is beneficial than Stored Procedures?
 Ask Question

How LINQ is beneficial than Stored Procedures?

Last updated:9/20/2020 11:07:47 PM

1 Answers

Anupam Mishra
Anupam Mishra

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!

report abuse

Answer

© Copyright © 2010 - 2021 MindStick Software Pvt. Ltd. All Rights Reserved