Explain how LINQ is useful than Stored Procedures?

Technology CommunityCategory: LINQExplain how LINQ is useful than Stored Procedures?
VietMX Staff asked 3 years ago
  • Debugging: It is difficult to debug a stored procedure but as LINQ is part of.NET, visual studio debugger can be used to debug the queries
  • Deployment: For stored procedure, additional script should be provided but with LINQ everything gets compiled into single DLL hence deployment becomes easy
  • Type Safety: LINQ is type safe, so queries errors are type checked at compile time