Entity Framework eSQL hierarchical query
It would be very beneficial to users that must work with massive amounts of hierarchal data to be able to perform hierarchical queries against our data using Entity SQL (eSQL), something like functionality provided by SQL CTE queries or Oracle's hierarchical queries.
Please provide some kind of similar recursive/hierarchical functionality without requiring direct access to the database server's native query language; it negates the purpose of using an abstraction layer to begin with.
Thanks for taking the time to share this suggestion. This item has been around for a couple of versions of Visual Studio and we haven’t acted on it. Looking at the VS “15” plans, we’re not going to take action on this item, so we’re going to close it. If the suggestion is still relevant, please either take a look to see if there’s another suggestion that’s similar that you can vote on, or open a new suggestion.
- The Visual Studio Team