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?