Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Recursive CLR - appdomain unloaded Expand / Collapse
Author
Message
Posted Monday, March 12, 2012 11:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:56 AM
Points: 1,270, Visits: 1,404
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?
Post #1265389
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse