Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Disadvantage of LINQ over Stored procedure?
on 5/14/2013 | Category:
LINQ Interview questions
| Views: 2008 |
Stored procedure compiles one time and executed every time whereas LINQ compiled everytime , so Stored Procedure is faster as compare to LINQ.
Many Interviews |
< Previous :
You are developing WCF service which read message ...
Next > :
What is different between LINQ and Stored Procedur ...
Comments or Responses
on: 5/15/2013 |
- 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
What is different between LINQ and Stored Procedure?
IEnumerable Vrs IQueryable
What are deep zoom and deep zoom composer?
Which browsers support Silverlight?
Which platforms support Silverlight?
For Windows,what are system requirement for Silverlight?
Expression Studio orVisual Studio, which one better to use for develop ...
What is Silverlight SDK?
Latest Interview Questions
How Big SQL Works?
What is BigSQL?
What is Impala?
What is Hive?
What is anonymous types?
What is JAQL ?
Difference between Web Services and DCOM
Difference between JIT compiler and an interpreter