what are the drawbacks when we use linq

Posted by Jameschowdare under Regular Expressions on 1/22/2010 | Views : 5996 | Status : [Member] | Replies : 4
what are the drawbacks when we use linq or disadvantages of linq




Responses

Posted by: Nishithraj on: 1/25/2010 [Member] Bronze

Up
0
Down
It's very obvious that linq is a special feature and reduces a lot of works.

But large sets of data in the linq can generate some performance issues. However microsoft provides remedy for that. Check the following link.

http://msdn.microsoft.com/en-us/magazine/cc721610.aspx

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Jameschowdare, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nishithraj on: 1/22/2010 [Member] Bronze

Up
0
Down
The main drawback that I would suggest you is the performance.

Check this article for more details http://www.codeproject.com/KB/dotnet/LINQ_Performance_Test.aspx



Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Jameschowdare, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Abhi2434 on: 1/22/2010 [Member] [Microsoft_MVP] [MVP] Silver

Up
0
Down
No there is no issue with this little jem. Its a great one to integrate your query into your application.

But Actually it generates loop based on what you instruct to the compiler. So if you think of the perspective of how it helps you, there wouldnt be any issue with LINQ.

And dont look at the Article just mentioned above, as that was written in 2007 and there are lots of changes made in API since then.

Also with the introduction of PLINQ you can run your linq query in Multicore system.

Cheers.

www.abhisheksur.com

Jameschowdare, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: RtpHarry on: 1/23/2010 [Member] [MVP] Bronze

Up
0
Down
There are no disadvantages to linq itself - its an awesome data query language.

With linq2sql however, there have been some noted issues with high performance websites but in general I think the generated sql is pretty well optimised.

You can always override the default generated and use sprocs if you need to tweak a specific query.

This article mentions performance issues when building a site using lambdas and linq:
http://www.codeproject.com/KB/ajax/Web20Portal.aspx


Jameschowdare, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response