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

1 Nov 2007 1:41 AM

DR

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

1 Nov 2007 5:21 PM

William Vaughn

I would take this the sqlserver.clr group.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

Show quote

"DR" <softwareengineer98***@yahoo.com> wrote in message
news:OlJmXhCHIHA.4808@TK2MSFTNGP05.phx.gbl...
> 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
>
>