Skip to content

HierarchyId

Simon Hughes edited this page Oct 12, 2016 · 20 revisions

If any of your tables uses the SQL HIERARCHYID type, please install the following package:

Install-Package EntityFrameworkWithHierarchyId

Here is a demo of the AdventureWorks 2012 and 2014 databases which makes use of the HIERARCHYID type: AdventureWorksDemo.zip

My thanks to Miguel Vrolijk for the following info:

Using both HeirarchyId and Table-valued functions

One issue that I’ve encountered is that you can’t use both HierarchyId columns and Table-valued functions as is. You need to compile the CodeFirstStoreFunctions library with the EntityFrameworkWithHierarchyId library instead of the EntityFramework library; the version on NuGet was compiled with the latter.

Clone this wiki locally