Search:
Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in LINQ

Interview Question :: Difference between LINQ and Stored Procedures?

What are the main difference between LINQ and Stored Procedures?

by ksk

advantage of LINQ LINQ and Stored Procedures LINQ Debugging LINQ Deployment LINQ Type Safety LINQ to SQL

VoteNow

Answers to "Difference between LINQ and 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!

by ksk

Search questions and share your knowledge with the world here on Questionpoint.

:: Categories ::

Interview Question in LINQ

Interview Question :: Difference between LINQ and Stored Procedures?