I have created several CLR'S for several webservices but i had no need to update my tables until now, most of my CLR'S return data to the cusstomer but now i have a CLR that receives information from a webservice and updates my data, When running a Select
statement within the CLR everything is fine but when I send and update statement the CLR times out without good explanation. the code below is what Im using and that will reproduce the problem.
Partial Public Class StoredProcedures
<System.Security.Permissions.PermissionSet(System.Security.Permissions.SecurityAction.Assert, Unrestricted:=True)> _
Public Shared Sub sp_Request_TransNetwork()
Using conn As New SqlConnection("context connection=true")
ssql = "select fields from my table" --this works perrfect!!!
View Complete Post