Buy Questpond's video subscriptions on
huge discount
.
Online: 1531
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
LINQ
>
Loading ...
Disadvantage of LINQ over Stored procedure?
Posted by
Sumank
on 5/14/2013 | Category:
LINQ Interview questions
| Views: 3938 |
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
< Previous :
You are developing WCF service which read message ...
Next > :
What is different between LINQ and Stored Procedur ...
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
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
More ...