how LINQ is useful than Stored Procedures?

Gajendra Jangid

8y2.8k.NET

2 Answers

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.

Rajeev Kumar3y

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

Gajendra Jangid8y