Support SQL Server HierarchyId data type


Please see the discussion related to this issue - http://entityframework.codeplex.com/discussions/415185

This item was migrated from the DevDiv work item tracking system [ID=134845].
Closed Dec 5, 2016 at 10:34 PM by RoMiller
EF Team Triage: We are transitioning this project to GitHub (https://github.com/aspnet/EntityFramework6). As part of this transition we are bulk closing a large number of issues in order that our new issue tracker will accurately reflect the work that our team is planning to complete on the EF6.x code base.

Moving forwards, our team will be fixing bugs, implementing small improvements, and accepting community contributions to the EF6.x code base. Larger feature work and innovation will happen in the EF Core code base (https://github.com/aspnet/EntityFramework). Closing a feature request in the EF6.x project does not exclude us implementing the feature in EF Core. In fact, a number of popular feature requests for EF have already been implemented in EF Core (alternate keys, batching in SaveChanges, etc.).

This is a bulk message to indicate that this issue was closed and not ported to the new issue tracker. The reasons for not porting this particular issue to GitHub may include:
• It was a bug report that does not contain sufficient information for us to be able to reproduce it 
• It was a question, but sufficient time has passed that it's not clear that taking the time to answer it would provide value to the person who asked it 
• It is a feature request that we are realistically not going to implement on the EF6.x code base
Although this issue was not ported, you may still re-open it in the new issue tracker for our team to reconsider (https://github.com/aspnet/EntityFramework6/issues). We will no longer be monitoring this issue tracker for comments, so please do not reply here.


RoMiller wrote Jan 24, 2013 at 10:27 PM

EF Team Triage: We agree that this would be a good scenario to enable. Taking into account where we are in the EF6 release along with the size and the impact of this feature our team is not planning to implement it in EF6. Therefore, we are moving it to the Future release to reconsider in the next release.

tomato45un wrote Mar 22, 2014 at 9:11 AM

Hi EF Team,

HierarchyId it's been introduce in SQL Server 2008, How come this data type still not support in EF 6.1.

mrrob wrote Jun 30, 2014 at 4:13 PM

Many serious large scale applications use hierarchies for many different important business entities. The list of uses is huge. We badly need hierarchyID implemented EF.

DennisTycho wrote Apr 1, 2015 at 7:47 AM

Hi EF Team,

Has any considerations been made regarding this issue? It seems completely nuts that this feature has not yet been implemented, almost 7 years after it was introduced in SQL Server. Making developers working on this technology each having to develop their own workarounds.

Please pay attention to this issue!!!

Corix010 wrote May 18, 2016 at 4:08 PM

Hi EF Team,

Please, we need EntityFramework support for HierarchyId. Someone created a small extension / fork for EntityFramework (https://www.nuget.org/packages/EntityFrameworkWithHierarchyId/) to support HierarchyId though it works to some extent but as soon as we add other packages that has dependency on EF, our app breaks.