如何从 BizTalk SendPort 执行存储过程?
我想从 SendPort 调用存储过程。我想避免编排,而是根据接收端口和消息类型创建消息框的订阅。我还需要使用收到的消息 xml 中的属性作为存储过程的参数。
我的假设是我应该使用 WCF-SQL 适配器。然而,我发现的唯一例子需要 20 个步骤的过程和一些魔法/运气……哦,是的,还有一个编排。我是否疯狂地认为这应该比看起来简单得多?有人可以为我提供资源或建议吗?
I would like to call a stored procedure from a SendPort. I want to avoid an orchestration and instead, create a subscription to the message box based on the receive port and message type. I also need to use attributes from the received message xml as parameters for my stored procedure.
My assumption is that I should use WCF-SQL adapter. However, the only examples I have found require a 20 step process and some magic/luck... oh yeah, and an orchestration. Am I crazy for thinking this should be way simpler than it seems? Can anyone provide me with resources or advice?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
您查看的示例之一是理查德·塞罗特 (Richard Seroter) 书中摘录的吗?
http://www.packtpub.com/article/soa-capability- in-bizTalk-wcf
您想做的事情无需编排即可完成。
Is one of the examples you looked at the excerpt from Richard Seroter's book?
http://www.packtpub.com/article/soa-capabilities-in-bizTalk-wcf
What you want to do can be done without an Orchestration.