Fastest way to move XML document into and back out of CLR function

Fastest way to move XML document into and back out of CLR function

In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass
an xml data type variable into a C# CLR function and retrieve it back out of
the C# CLR function when the C# CLR function is done modifying it?

I tried this but get deployment error becuase SQLServer2005/CLR dotn support
System.Xml.XmlDocument:

public partial class UserDefinedFunctions
{
[Microsoft.SqlServer.Server.SqlFunction]
public static int InsertSomeNode(System.Xml.XmlDocument pDoc)
{
//
return 1;
}
};

thorws error:
Error 1 Column, parameter, or variable #1: Cannot find data type
XmlDocument. InsertSomeNode


.

Relevant Pages

  • Re: Fastest way to move XML document into and back out of CLR function
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass an xml data type variable into a C# CLR function and retrieve it back out of the C# CLR function when the C# CLR function is done modifying it? ... public partial class UserDefinedFunctions ... Error 1 Column, parameter, or variable #1: Cannot find data type XmlDocument. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Fastest way to move XML document into and back out of CLR function
    ... Please don't post the same message multiple ... an xml data type variable into a C# CLR function and retrieve it back out ... public partial class UserDefinedFunctions ... Error 1 Column, parameter, or variable #1: Cannot find data type ...
    (microsoft.public.sqlserver.clients)
  • Fastest way to move XML document into and back out of CLR function
    ... Fastest way to move XML document into and back out of CLR function ... public partial class UserDefinedFunctions ... Error 1 Column, parameter, or variable #1: Cannot find data type ...
    (microsoft.public.dotnet.framework)
  • Fastest way to move XML document into and back out of CLR function
    ... Fastest way to move XML document into and back out of CLR function ... public partial class UserDefinedFunctions ... Error 1 Column, parameter, or variable #1: Cannot find data type ...
    (microsoft.public.dotnet.framework.adonet)
  • Fastest way to move XML document into and back out of CLR function
    ... Fastest way to move XML document into and back out of CLR function ... public partial class UserDefinedFunctions ... Error 1 Column, parameter, or variable #1: Cannot find data type ...
    (microsoft.public.dotnet.general)
Loading