Hi Folks,
I would like a the WCF adapter for SQL to allow calling SQL stored procedures with MULTIPLE paramaters, where the paramters can be XML data, constants and PROMOTED FIELDS
So, perhaps in the near future, this type of template will work in WCF-Custom. Where the template has access to the BizTalk Property Schema. Notice below we no longer use encoding type of string to the message, will be faster, of course this sort of template will never work now, but nice to have one day? It could be an add in for the Consume Adapter Service BizTalk Project Add-In where you can drag promoted property fields into the template. This should be possible, since the following assembly has direct access to the message and all properties:
System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
so template below in future would work in WCF-Custom:
(If template does not show, check my blog site for it:)
http://www.microsoft.com/schemas/bts2007" encoding="stream"/>
StageParam, StatusParam and IdParam are promoted properties of the message going into the adapter, and this should be possible, the WCF architecture can support this, since they already have the fixed property schema for:
bts-msg-body xmlns="http://www.microsoft.com/schemas/bts2007
I am excited about WCF, but it can be much more powerful with BizTalk if it can hook into Promoted Properties and not encode the message as a string, but default it to a stream.
Why????? Since SQL support XML, there is allot of times where you just want to push XML data into SQL Server avoiding Orchestrations and updategrams/insertgrams etc.
I blog covering this is here:
http://grounding.co.za/blogs/romiko/archive/2010/03/01/windows-communication-foundation-biztalk-adapter-wcf-custom.aspx
I know allot of BizTalkers love orchestrations and rightfully so, however there are times when they should be avoided, for example using them to map data to SQL can sometimes be an overhead that really is not needed if storing XML data directly in SQL and you need additional paramters.
HTH :)