0
Answer

Parent-Child relationship (HierarchyID) in Entity/Stored Pro

Ask a question
r p

r p

11y
1.6k
1

I am developing a website for an organization. In my table -"HumanResource" the names of all these people are stored as "HierarchyID" withParent Path and Path Level. I have to show  all these level as a tree model like :-

Company Directores=>General Managers=>Area Managers=>Local Managers=>Project Managers=>Members

I am using MVC3 and Entity Framework for my website. What is the best way to do it? If Entity Framework does not perform well then I can use Stored Procedure. Any idea?