WCF-SQL运行SP并从视图中获取数据 [英] WCF-SQL Running SP and get data from view

问题描述

大家好，

我需要配置接收位置（Wcf-SQL适配器），以便它应该运行存储过程并从之前运行的存储过程填充的视图中获取数据。

I need to configure receive location(Wcf-SQL adapter) such that it should run stored procedure and get data from view which is populated by stored procedure ran earlier.

请建议配置步骤。

提前致谢

推荐答案

请记住，sqlBinding（接收位置）仅与存储过程进行交互。 它不知道数据来自何处，因此将结果基于View对BizTalk组件没有任何影响。

Keep in mind, the sqlBinding (Receive Location) interacts only with the Stored Procedure.  It has no knowledge of where the data comes from so basing the results on a View will have no affect on the BizTalk components.

因此，您描述的SQL处理将完全发生在SP中然后可以根据需要将任何结果返回给调用者（BizTalk）。

So, the SQL processing you describe would happen entirely in the SP which can then return any results to the caller (BizTalk) as necessary.

这篇关于WCF-SQL运行SP并从视图中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！