WCF-SQL适配器和Sql适配器之间的区别 [英] The difference between WCF-SQL adapter and Sql Adapter

问题描述

我是BizTalk开发的新手.我正在使用BizTalk Server2010.我正在使用BizTalk 2006到2010迁移现有代码.在旧应用程序中，我们使用Sql适配器来获取用于xml文件的过程. 2010年的MSDN指定

I am new to BizTalk development. I am using BizTalk server 2010. I am doing a migration existing code which use BizTalk 2006 to 2010. In the old application we have used Sql adapter to get procedure out put for a xml file. MSDN for the 2010 specifies that

BizTalk Server不再支持SQL适配器.考虑使用Microsoft BizTalk适配器包来实现相同的功能. (http://msdn.microsoft.com/en-us/library/aa578608.aspx)

BizTalk Server no longer supports the SQL Adapter. Consider using the Microsoft BizTalk Adapter Pack to achieve the same functionality. (http://msdn.microsoft.com/en-us/library/aa578608.aspx)

但是当我安装BizTalk 2010时，它具有SQL适配器.他们说可以使用WCF_SQL适配器代替SQl适配器.我想知道这两个适配器之间的区别.我发现了一些博客.但是那些都帮不了我.如果有人知道，请分享

But when I install BizTalk 2010 it has the SQL adapter.And they said that WCF_SQL adapter can use instead of SQl adapter. I want to know the difference between those two adapters. I found some blogs. But those wan't help me. If anybody knows please share it

谢谢

推荐答案

SQL适配器已在BizTalk中永久可用(不确定它附带的版本，但至少从2004年开始).它可以工作，但是使用起来很奇怪(例如，默认情况下，它将所有内容包装在信封消息中).

SQL Adapter has been available in BizTalk forever (not sure which version it came in with but since at least 2004). It works but it is very quirky to work with (for example, it wraps everything in an envelope mesage by default).

WCF SQL适配器被设计为与SQL Server的最新版本一起使用，这些版本对XML作为sql类型具有本机支持.它提供了更好的功能，并且更好用.

WCF SQL Adapter was designed to work with the latest versions of SQL server which have native support for XML as a sql type. It provides much better functionality and is much nicer to work with.

因此，您不应该再使用SQL适配器是有充分的理由的.

So there's good reason why you shouldn't use the SQL adapter any more.

这篇关于WCF-SQL适配器和Sql适配器之间的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！