What are disadvantages of LINQ?

There are following disadvantages of using LINQ:

  • LINQ is not good to write complex queries like SQL.
  • If you have done some changes in your query, you have to recompile it and redeploy its dll to the server.
  • Small data sets will take longer to build the query than execute.
  • When queries are moved from sql to application side, joins are very slow.
  • DBML concurrency issues.
  • Hard to understand advance queries using Expressions.

Related posts:

  1. What are different flavors of LINQ?
  2. What is LINQ and why to use it?
  3. Which namespace is necessary to use LINQ?
  4. What are advantages of LINQ?