Difference between Linq and Store Procedure

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 reallygood to encounter an error when compiling rather than runtime exception!