Disadvantage of LINQ over Stored procedure?

 Posted by Sumank on 5/14/2013 | Category: LINQ Interview questions | Views: 3732 | Points: 40

Stored procedure compiles one time and executed every time whereas LINQ compiled everytime , so Stored Procedure is faster as compare to LINQ.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Rabbil on: 5/15/2013 | Points: 10
- LINQ tends to be more generic than Sprocs (as sproc can take full advantage of dataset features). This is common in any kind of language abstraction (e.g. C# vs assembler).
- LINQ needs to send the entire query over the network whereas Sprocs need only serialize sproc-name and argument data over the wire.

Login to post response