Qus:    Difference between LINQ and SQL Stored Procedure?
Dec 23, 2020 12:34 2 Answers Views: 77 FRAUSKY
Prev Next
Answers (2)
PARTH Dec 24, 2020 07: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 09: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 course is right for you?

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

Let`s Connect