Does Linq to SQL or Linq to Entities 4.0 support a hierarchical data type?

Question

Is their way of using linq for SQL / Entities 4.0 to work with a hierarchical data type?

Answer 1

None of Microsoft's ORM families currently use CLR User-Defined Types (including built-in hierarchyidand geospatial types) as column types.

If you use them in your database, you have two ways:

• CAST(hid AS varbinary892)). ( ), Linq. .

  , "" hierarchyid , Microsoft.SqlServerTypes BinaryReader/BinaryWriter BLOB / SqlHierarchyId.

  , Linq . , " ". , .

• , , , hierarchyid L2S/EF. hierarchyid . UDF , .

  , , . Microsoft hierarchyid, , . hierarchyid .

  , , , hierarchyid , Dennis, . , hierarchyid , .

  Microsoft - hierarchyid ORM, hierarchyid. , hierarchyid, ( "" ), SQL UDF .

Answer 2

, . , . ,

Answer 3

Aaronaught Linq to SQL.

    TreeId.ToString()

    [TreeId].[GetAncestor](1).ToString()

.

, Dbml .

.