The WCF LOB SQL Adapter is the adapter in the BizTalk Adapter Pack 2010 that offers connectivity to SQL Server databases. It is very common for BizTalk Server solutions to interact with SQL Server databases, making this one of BizTalk's most popular adapters. Like all adapters in the pack it is based on the Microsoft Windows Communication Foundation Line-of-Business Adapter SDK (ASDK). As described in Chapter 1 it can not only be consumed from BizTalk Server solutions, but also from any .NET-based application.
The WCF LOB SQL Adapter (further in the chapter we refer it as the ASDK SQL adapter or just the adapter) should be used as a replacement for the old SQL Adapter. The ASDK SQL adapter offers a variety of new features, improved performance, and supports all versions of SQL Server since SQL Server 2000. The old SQL Adapter relied upon the SQLXML features of SQL Server, whereas the new adapter follows the .NET Framework and communicates with SQL Server through...