Debugging: It is difficult to debug a stored procedure Compare to LINQ.We can easly debug LINQ query with visual studio debugger. Deployment: In LINQ everything exist in single DLL so deployment of linq is vary easy but in SP additional script should be provided. Type Safety: LINQ is type safe, so queries errors are type checked at compile time
LINQ has full type checking at compile-time and Intellisense support in Visual Studio as compared to a stored procedure. This powerful feature helps you to avoid run-time errors. LINQ allows debugging through . NET debugger as compared to a stored procedure.