This is the first time I've tried a recursive CLR routine. It all compiles and runs from a .NET test application. but whenever recursion starts, when called from SQL, the function call fails with
Msg 6535, Level 17, State 49, Line 12
.NET Framework execution was aborted. Another Query caused the MyNameSpace.dbo.[runtime].x to be unloaded
The recursive routine uses generics - and has method signature
private int EvaluateSubClause(List<string> subClause)
Can anyone point me to a working example of a recursive C# method used in a SQL CLR function or procedure?