HierarchyID in Entity Framework not working

Question

We are using WCF Data Service based on an Entity Framework model for our application.

In this we need to add the table with a column of type HierarchyId. When I add that table to the EDMX file, the HierarchId column is not appearing in the class file.

What should I do to make use of HierarchyID? I read that Entity Framework is not supporting HierarchyID, so how can I achieve this?

Your problem is with EF, not WCF. The problem is that EF can't represent hierarchyid columns. — Gabe
– Gabe, Commented Nov 30, 2010 at 18:52
I used this little bit of code to make working with HierarchyID strings a bit easier... stackoverflow.com/questions/3347860/… — EBarr
– EBarr, Commented Feb 29, 2012 at 16:46
@EBarr, Your implementation looks good, my requirement was just use the existing HierarchyID as it is. The only thing i did was, used computed Column since EF don't support. By the use of computed column, its doing its job great. — Mohanavel
– Mohanavel, Commented Mar 1, 2012 at 10:14

marc_s · Accepted Answer · 2010-12-01 07:50:28Z

24

You can always convert a HierarchyId to its string representation - something like /1/3/4/1 - and send that string across the WCF data service.

Update: if you add this computed, persisted column to your SQL Server table, that new column should definitely show up in your EF model and you should be able to use this to send it back over WCF and WCF Data Services:

ALTER TABLE dbo.YourTable
ADD HierarchyString AS (your hierarchyID field).ToString() PERSISTED

Update #2: read the docs! You can parse back a string like /1/3/4/1 into a HierarchyId type - either use the HierarchyId::Parse(string) or the usual CAST(string as HierarchyId) methods to do so.

edited Dec 1, 2010 at 7:50

answered Nov 30, 2010 at 17:28

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mohanavel Over a year ago

As i told early, while adding the table to the EDMX file, the hierarchyId field is not appearing. So i have to have method in svc file and insert using "insert into ... " query?

Mohanavel Over a year ago

OK, This can be used as getter, how about setter? i tried the setter kind of stuff. If setter is possible, everything can be done in simpler way. By using this i'm able to get the data. Thanks marc_s.

Community · Accepted Answer · 2017-05-23 12:06:14Z

10

If you use the computed column just keep in mind that you will also need the DatabaseGenerated data annotation on your property like this:

[DatabaseGenerated(DatabaseGeneratedOption.Computed)]
public string HierarchyString { get; set; }

Check this article out for more info: Entity Framework Code First Computed Properties

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Aug 2, 2011 at 14:42

Eric

3,8322 gold badges35 silver badges28 bronze badges

Collectives™ on Stack Overflow

HierarchyID in Entity Framework not working

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related