dbTalk Databases Forums  

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

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Fastest way to move XML document into and back out of CLR function in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DR
 
Posts: n/a

Default Fastest way to move XML document into and back out of CLR function - 10-31-2007 , 07:41 PM






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



Reply With Quote
  #2  
Old   
Mike C#
 
Posts: n/a

Default Re: Fastest way to move XML document into and back out of CLR function - 11-01-2007 , 05:05 PM






Answered in .sqlserver.xml. Please don't post the same message multiple
times in different groups, put all group names you want the message to go to
in the message at once. This helps prevent people wasting time answering
questions that have already been answered in other groups.

"DR" <softwareengineer98037 (AT) yahoo (DOT) com> wrote

Quote:
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





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.