Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 1821
Home > Interviews > LINQ >

Disadvantage of LINQ over Stored procedure?

 Posted by Sumank on 5/14/2013 | Category: LINQ Interview questions | Views: 3525 | Points: 40
Post | Interview FAQs | Exclusive Questions | Interview Home  
Answer:

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 

Bookmark It

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

More Interview Questions by Sumank


Latest Interview Questions