1.We can debug LINQ as it is part of .Net, whereas Stored procedure can’t be.
2. Deployment is easy with LINQ as everything compiled into DLL whereas with Stored procedure script is required for deployment.
3. At compile time we can find error, if any in LINQ but it not possible with Stored procedure.
Asked In: Many Interviews |