This option might also prove useful:
LINQ AsHierarchy() extension method
http://www.scip.be/index.php?Page=ArticlesNET18
More Related Contents:
- Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
- Get top 1 row of each group
- Convert Month Number to Month Name Function in SQL
- How to avoid the “divide by zero” error in SQL?
- Insert data in 3 tables at a time using Postgres
- Generate a resultset of incrementing dates in TSQL
- Real life example, when to use OUTER / CROSS APPLY in SQL
- Getting result of dynamic SQL into a variable for sql-server
- How to get difference between two rows for a column field?
- Better techniques for trimming leading zeros in SQL Server?
- Select info from table where row has max date
- Sql Server equivalent of a COUNTIF aggregate function
- Dynamic SELECT TOP @var In SQL Server
- Common Table Expression, why semicolon?
- What’s the best way to select the minimum value from several columns?
- Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
- varbinary to string on SQL Server
- SQL : in clause in stored procedure:how to pass values
- SQL GROUP BY CASE statement with aggregate function
- separate comma separated values and store in table in sql server
- Best way to do nested case statement logic in SQL Server
- SQL Server 2005 ROW_NUMBER() without ORDER BY
- How to use multiple CTEs in a single SQL query?
- Cumulative Total in MS Sql server [duplicate]
- SQL query to group by day
- Export table data from one SQL Server to another
- SQL: Aggregating strings together
- Distributed transaction error?
- SQL, How to Concatenate results?
- Determine what user created objects in SQL Server