manan

Hi,

I’m doing a POC for my client using BizTalk 2009 (which is great �)
and I need to use the SQL adapter.
BizTalk 2009 now provides the WCF LOB based SQL adapter. But my main
question is, why do we have a separate WCF-SQL adapter and WCF-Custom
(with SQL binding)? Which one to use? Are there any pros and cons of
using each of this? Any input on this will be very helpful.
Also in previous version of SQL adapter (BTS 2006) we need to cluster
the host instance to avoid the race condition and to avoid the receive
location getting disabled? Does the same apply with the new WCF based
adapter as well or now we don't need to cluster the host instance?

Thanks in advance.