search

zzzprojects / EntityFramework-Classic

Entity Framework Classic is a supported version of the latest EF6 codebase. It supports .NET Framework and .NET Core and overcomes some EF limitations by adding tons of must-haves built-in features.
https://entityframework-classic.net
Other
102 stars 27 forks source link

Cte support #33

Open matt-psaltis opened 5 years ago

matt-psaltis commented 5 years ago

Hi there just wondering if there's any plans to support ctes (common table expressions)

JonathanMagnan commented 5 years ago

Hello @SaltyDH ,

Do you have something specific in mind? What exactly you would like we add with CTE?

We are supposed next week to bring the feature ToSelfHierarchyList in EF Classic which used CTE: https://entityframework-extensions.net/to-self-hierarchy-list

Best Regards,

Jonathan

matt-psaltis commented 5 years ago

Something along the lines of this. https://linq2db.github.io/articles/sql/CTE.html

We use it for a variety of bespoke queries to provide the main query with additional data.

JonathanMagnan commented 5 years ago

Look great,

We will for sure look at it next week and see if there is anything we can do.

tsanton commented 7 months ago

@JonathanMagnan did you ever look into this issue?

JonathanMagnan commented 7 months ago

Hello @tsanton ,

It might eventually happen, but this is currently not on our priority list at all.

We surely started to use CTE for some features we recently added, like WhereBulkContains, but still do not provide a direct way of using it.

Best Regards,

Jon