Recursive CLR - appdomain unloaded

• Tom257

  SSChampion

  Points: 11543

  More actions

  March 12, 2012 at 11:00 am

  #254541

  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?