The Microsoft BizTalk Adapter for SQL Server is a Windows Communication Foundation (WCF) binding. Client applications can consume the SQL adapter to invoke operations on SQL Server artifacts. The SQL adapter can be consumed:
Through a physical port binding in a BizTalk Server solution.
By invoking methods on an instance of a client proxy.
As a hosted WCF service.
By sending SOAP messages over a channel instance in code that uses the WCF channel model.
BizTalk vs WCF service vs WCF channel
The following table:
Lists the different operations that can be performed on SQL Server using the SQL adapter.
Provides links to the topics containing information about performing the task using the chosen approach (BizTalk Server, WCF service model, WCF channel model).
WCF Service Model
WCF Channel Model
Performing basic Insert, Update, Delete, and Select operations on tables and views