从Orchestration调用的WCF-SQL存储过程 [英] WCF-SQL Stored Procedure calling from Orchestration
问题描述
您好,
我有一个存储过程,它返回4个数据集/ XML作为输出。当我使用轮询间隔从接收端口使用此过程并且使用属性XMLStoredProcedureRootNodeName和XMLStoredProcedureRootNodeNamespace时,它将仅返回带有指定RootNode和Namespace的单个
XML。现在我想使用与Orchestration中的Request-Response端口相同的过程。
当我使用WCF-Custom或WCF-SQL时,两个属性都不绑定XMLStoredProcedureRootNodeName和XMLStoredProcedureRootNodeNamespace。 / p>
我收到结果集和4个数据集的回复。
请指导我缺少的物业。
问候,
Saurin
非常重要的问题,存储过程是否使用FOR XML?
返回4个数据集是SQL Server + WCF sqlBinding的默认行为。
Hello,
I have stored procedure which return 4 Dataset/XML as output. When I use this procedure from receive port using polling interval and with properties XMLStoredProcedureRootNodeName and XMLStoredProcedureRootNodeNamespace it will return only single XML with assigned RootNode and Namespace. Now I want to use the same procedure as Request-Response port from my Orchestration.
When i use WCF-Custom or WCF-SQL both property are not binding XMLStoredProcedureRootNodeName and XMLStoredProcedureRootNodeNamespace.
I am receiving my Response with result set and 4 data set.
Please guide me what Property i am missing.
Regards,
Saurin
Very important question, does the Stored Procedure use FOR XML?
Returning 4 datasets is the default behavior of SQL Server + WCF sqlBinding.
这篇关于从Orchestration调用的WCF-SQL存储过程的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!