Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax

by

AFAIK there is no support for recursive CTEs in LINQ nor in EF. The solution is to expose the CTE as a view. The article on Recursive or hierarchical queries using EF Code First and Migrations shows how to deploy such a view using EF code first migrations.

Attempting to emulate CTEs by doing recursive client side iterations does not scale to large data sets and results in a chatty exchange with the server. Note how your EF code returns IEnumerable not IQueryable, it means that it materializes each level and then concatenates the next level for each entry as a separate request. The LINQ based solution will work reasonably for shallow hierarchies with limited entry count (and note that many projects can have such data layout, user posts/answers being a typical example), but will crumble under deep hierarchies with many elements.

More Related Contents:

  1. Entity-framework code is slow when using Include() many times
  2. The LINQ expression could not be translated and will be evaluated locally
  3. Dynamic query with OR conditions in Entity Framework
  4. Should the order of LINQ query clauses affect Entity Framework performance?
  5. summing values of a column based on id [closed]
  6. MSSQL Error ‘The underlying provider failed on Open’
  7. ‘Contains()’ workaround using Linq to Entities?
  8. How to use a string to create a EF order by expression?
  9. The type of one of the expressions in the join clause is incorrect in Entity Framework
  10. LEFT JOIN in LINQ to entities?
  11. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  12. How to compare only date components from DateTime in EF?
  13. How to Bulk Update records in Entity Framework?
  14. Entity Framework 6 Code First Custom Functions
  15. EF 6 – How to correctly perform parallel queries
  16. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  17. Order by dynamic parameter
  18. Dynamic table name in linq [duplicate]
  19. Delete a single record from Entity Framework?
  20. Linq Syntax – Selecting multiple columns
  21. Join and Include in Entity Framework
  22. Entity Framework 6 transaction rollback
  23. Creating dynamic queries with entity framework
  24. Log Queries executed by Entity Framework DbContext
  25. Remove item from list based on condition
  26. How to Identify the primary key duplication from a SQL Server 2008 error code?
  27. How to group by DateTime.Date in EntityFramework
  28. How to include() nested child entity in linq
  29. Watch for a table new records in sql database
  30. LINQ Query to Convert string to datetime

Leave a Comment