none
EF 6.1 support HierarchyID datatype yet? Version 6 apparently does not RRS feed

  • Question

  • Does EF 6.1 support the SQL 2008 datatype HierarchyID?  I see this question come up a lot, but in older threads.  I am using version 6.0 and tried to create a model with some tables that have hierarchyid datatypes and ran into errors that mentioned the datatype was not supported.  Any change with version 6.1?

    Monday, July 14, 2014 12:35 PM

Answers

All replies

  • I suppose one work around if I need to, is to wrap all interaction with tables that have this datatype, with stored procedures.

    Monday, July 14, 2014 12:42 PM
  • Hi Suchit,

    I cannot see HierarchyID support in Entity Framework 6.1, you can see Entity Framework Version History from http://msdn.microsoft.com/en-us/data/jj574253. You can also ask for this feature on Visual Studio UserVoice, open a thread on https://visualstudio.uservoice.com/forums/121579-visual-studio.

    See a workaround on StackOverflow. http://stackoverflow.com/questions/14363332/entity-framework-hierarchyid-workarounds.

    Regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. <br/> Click <a href="http://support.microsoft.com/common/survey.aspx?showpage=1&scid=sw%3Ben%3B3559&theme=tech"> HERE</a> to participate the survey.

    • Marked as answer by shiftbit Tuesday, July 15, 2014 12:38 PM
    Tuesday, July 15, 2014 5:46 AM
    Moderator
  • Thanks.  Ive read through those links.  Also, on 2nd thought I cant use the stored procedure approach either, since I would also have FK relations that would require bringing in the tables with hierarchyid types into the model.  So this is a breaker for me.  I really dont want to use a "custom" EF build either that isnt part of the official release.  Im back to using an approach that doesnt involve this datatype.

    Tuesday, July 15, 2014 12:40 PM