What is CrazyEngico.com (CE)?

CrazyEngico (CE) is a one-stop solution for interview questions and answers, domain knowledge, e-learning, tutorials, articles and many more learning material.
e-learning - Intelligent e-learning tutorials and articles
Domain Knowledge Learn about various business domains/verticals such as Banking, Financial, Insurance, Healthcare and many more...
Interview Questions and Answers - Post your questions and answers. 1000+ database of ready questions and answers available to prepare for an interview.
Tutorials - 300+ video tutorials from beginner to expert level.
Articles - 300+ technical articles to understand concepts.
Forum - A technical forum to post your queries/responses.

Search Questions

Interview Questions/Answers

Interview Q & A >> LINQ >> What are the pros and cons of LINQ (Language-Integrated Query)?

Question Navigator Next >>

1        0
What are the pros and cons of LINQ (Language-Integrated Query)? (Views: 3719)


7        5

LInQ is used in case of reducing Burdan on sql server for all Querys to fetch data

DIsadvantage of LinQ is it will create as many objects
for example if i have a class named Emp with 4 records in it so linQ will create it as
emp class in dotnet(front end) with 4 objects(records of it)

so here on wards we sort or filter or perform operations on these objects just like we do in sql server

but the main desadvantage with linQ is if my tale have 1 lakh records it have to create 1 lakh objects in dotnet which makes my programe get cubersome running these objects

santosh kakani

Submitted By: santosh kakani | Created On: 5/18/2011 1:31:15 AM

1        0

Pros of LINQ:

  • Supports type safety
  • Supports abstraction and hence allows developers to extend features such as multi threading.
  • Easier to deploy
  • Simpler and easier to learn
  • Allows for debugging through .NET debugger.
  • Support for multiple databases

Cons of LINQ:

  • LINQ needs to process the complete query, which might have a performance impact in case of complex queries
  • LINQ is generic, whereas stored procedures etc can take full advantage of database features.
  • If there has been a change, the assembly needs to be recompiled and redeployed.

Submitted By: Manisha Kamble | Created On: 4/18/2012 2:26:10 AM

Post your Answer
Your answer will be first reviewed by our administrator before it appears on the site.

Your Answer:

Display Name:

By clicking on Submit button you agree to the Terms of Service agreement.

Copyright © 2018 CrazyEngico.com. All rights reserved.
CrazyEngico.com is not responsible for the content and CrazyEngico.com does not evaluate or guarantee the accuracy of any CrazyEngico.com content.
Please read our terms of service agreement before using this site.