Support for hierachical queries and HierarchyID
One of the things that most simple business applications require is heirarchy. Whether it be a tree for data selection or a threaded comment set, Heirarchy is horrible to implement in EF and LINQ - I'd like to see methods that support it better.
Support for HierarchyId and Federation will determine if we use EF for next app.
John, Mark: I have added HierarchyID to a fork of EntityFramework on CodePlex:
http://entityframework.codeplex.com/SourceControl/network/forks/zgabi/EfHierarchyIdAlpha3 (sometimes i change the fork name, but you can always find the source on CodePlex)
I know that it is not the official EF, but if you need HierarchyID, maybe you can try it.
EF is currently in alpha3 state but I'll merge the modification to all releases of EF6. (Because I need it, too:))
You can see an example here:
HierarchyId support is a required need for our new application and lack of support in EF is making it very difficult for us to use EF.
Alas, no HierarchyId support in EF yet. This is very important for my application. Please re-consider adding HierarchyID to EF.
Toby Harman commented
Mikkel Jakobsen commented