Sql Server query works in management studio but not in C# (ServiceStack.OrmLite)

The following recursive query works in SSMS, but not in a C# query in ServiceStack. It boils down to the query (I think)... or the fact that I'm using OrmLite... in SQL Server Management Studio the query works pretty great... it lists the records in a hierarchical (self referencing) table. The RowNumber is sweet because I can sort by id, name, whatever.The following recursive query works in SSMS, bu