Language Integrated Query (LINQ) Question:
Difference between LINQ and Stored Procedures?
Answer:
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!
4. PreCompiled - Stored Procedures are precompiled, and LINQ queries need to compile before execution. So stored procedures are fast in performance.
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!
4. PreCompiled - Stored Procedures are precompiled, and LINQ queries need to compile before execution. So stored procedures are fast in performance.
| Previous Question | Next Question |
| Why Select clause comes after from clause in LINQ? | What are Benefits and Advantages of LINQ? |