What I need to do, I have a comment table using the HierarchyID data type on the sql server and would like this to map to the Code First / EF 4.3 class. How can I achieve this?
Also how can I interact with the hierarchyID when inserting / deleting. Thank you very much.
This is a possible duplicate of the HierarchyID in Entity Framework not working
EF does not support this data type http://thedatafarm.com/blog/data-access/sql-server-2008-data-types-and-entity-framework-4/
I'm not used to the data type, but I did some research.
, SQL Server , CLR. , (. ).
, - , hierarchyid nvarchar(4000). , // , EF. , EF Code First SP , , .
hierarchyid
nvarchar(4000)
, .