Storing URIs in SQL Server 2008 using the HIERARCHYID datatype and LINQ-To-SQL

I’ve been playing around with SQL Server 2008 CTP, exploring the benefits of the new HIERARCHYID datatype, which has been designed to efficiently store depth-first tree structures in SQL Server 2008. My requirements were to store URI paths such as ones you might find in URLs, whereby each path component is held as a separate record in a table. Each path component refers to a folder in file system, e.g. URL: http://www.vamosa.com/index/information_solutions/technology_and_products/vamosa_content_migrator.htm URI: path:...