Qus:    Difference between LINQ and SQL Stored Procedure?
Dec 23, 2020 18:34 DotNet 2 Answers Views: 1154 FRAUSKY
Prev Next
Answers (2)
PARTH Dec 24, 2020 13:39
Answer:   1. In LINQ errors are checked at compile time whereas for stored procedure errors are checked at runtime.
2. In LINQ there is no need for additional script because LINQ works under .NET framework using only one DLL whereas in stored procedure we need additional script.
3. Performance wise stored procedure is faster than LINQ because it executes on server only.

SHIVA Dec 24, 2020 15:10
Answer:   LINQ Based Solution deployment is easier than using Stored procedures. LINQ uses .NET debugger and supports multiple databases. Whereas Stored Procedures need to be rewritten for multiple databases.

Post Your Answer
Guest User

Not sure what solution is right for you?

Choose the right one for you.
Get the help of the experts and find a solution that best suits your needs.


Let`s Connect