Why Store Procedures are faster than LINO Query?

SPs are faster from LINQ because they have pre

compiled execution plan, so after first time cached

executed plan is used which created impacts.

SP(s):

It's difficult to debug them

Procedure run on server side

For complex queries itis best

⁃ It consumes database resources

For deployment we have to provide scripts

SP can't perform best if you are not good at writing

optimized queries, be careful

LINQ:

It is compiled each and every time

⁃ It is not suitable for complex queries

- LINQ is type safe and easy to debug

You should know how to write better LINQ queries

for better performance

- LINQ isn't good for bulk operations, although

n.NET 7 we have got the bulk operations, let's see if

they can perform better than SP(s)

Short Coding Snippet