What are disadvantages of LINQ over Stored Procedures?
Answer / Ravi Kant
One disadvantage of LINQ over Stored Procedures is performance. Since LINQ executes queries directly against the database, it may not be as optimized as stored procedures which can be compiled and cached for reuse. Another disadvantage is that stored procedures provide more control over transaction management and security.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are different methods to write LINQ Query?
What is linq in sql?
Explain what is “LINQ to Objects”?
Can you disable lazy/deferred loading?
What is the use of firstordefault in linq?
What is LINQ Insight?
What is lambda expression in linq c#?
How to use GroupBy in LINQ?
What is a linq procedure?
What is linq to sql deferred loading?
List out the data context functions. Where do we use “submitchanges()"?
What is linqpad used for?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)