|
Home > Archive > BizTalk Server > February 2005 > Using maps with custom XSLT and C#
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Using maps with custom XSLT and C#
|
|
| Philippe Van der Stighelen 2005-02-15, 5:50 pm |
| Hello,
We found the mapper of limited use for mapping complex scenario's and
decided to write the stylesheet by hand.
This works fine, but now we need to connect to a database.
By default, the following namespaces are supported in the msxsl:script tag:
System System classes.
System.Collection Collection classes.
System.Text Text handling classes.
System.Xml Core XML classes.
System.Xml.Xsl XSLT classes.
System.Xml.XPath
But when connecting to a SQL DB, the System.Data namespace is needed.
Obviously, we added a reference to this namepace at project level, but we
keep
getting an error when testing the map, stating that the Data, Reader,Command
etc...could
not be found.
Any suggestions would be gretaly appreciated,
Philippe
| |
| Jon Flanders[DevelopMentor] 2005-02-15, 5:50 pm |
| You need to do what a linked functoid does - not what the inline functoids
do. You need to create a namespace that calls a .NET method and then call
the method, and give the mapper a CustomExtension Object xml file.
Add the Database Lookup functoid to a map - view the XSLT you should get the
idea.
--
Jon Flanders [DevelopMentor]
http://staff.develop.com/jfland/
http://www.develop.com/courses/biztalk
"Philippe Van der Stighelen" <jobs@genuine.be> wrote in message
news:%23vnQ3G6EFHA.3120@TK2MSFTNGP12.phx.gbl...
> Hello,
>
> We found the mapper of limited use for mapping complex scenario's and
> decided to write the stylesheet by hand.
> This works fine, but now we need to connect to a database.
>
> By default, the following namespaces are supported in the msxsl:script
> tag:
> System System classes.
> System.Collection Collection classes.
> System.Text Text handling classes.
> System.Xml Core XML classes.
> System.Xml.Xsl XSLT classes.
> System.Xml.XPath
>
>
> But when connecting to a SQL DB, the System.Data namespace is needed.
>
> Obviously, we added a reference to this namepace at project level, but we
> keep
> getting an error when testing the map, stating that the Data,
> Reader,Command
> etc...could
> not be found.
>
> Any suggestions would be gretaly appreciated,
> Philippe
>
>
|
|
|
|
|