Disadvantages of using LINQ?

Posted by Amatya on 3/21/2017 | Category: LINQ Interview questions | Views: 9076 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

a) In case of complex queries performance issues might occur as LINQ process the complete query as it is not a precompiled statement.
b) It does not take the full advantage of database features as LINQ is generic.
c) In case any change , assembly is recompiled.
d)No good way of view permissions.
e) impedance mismatch is still present, which is reasonable but needs to be understood

Thanks

Asked In: Accenture | Alert Moderator

Bookmark It

< Previous : Which one is Client type state management?

Next > : What will be the output of --Input Script --De ...

Comments or Responses

Posted by: Ajay2707 on: 8/29/2017 | Points: 10

It is very useful. One thing to add is linq query is not usefull when you have big database, do not preferrable as linq at server side memory will may be issue of perfomance.

Posted by: Amatya on: 9/1/2017 | Points: 10

yea . Exactly . Thanks for adding the point.
@Ajay2707

More Interview Questions by Amatya

Latest Interview Questions