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.
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).
|Task||BizTalk Server||WCF Service Model||WCF Channel Model|
Performing basic Insert, Update, Delete, and Select operations on tables and views
Performing operations on tables and views with large data type columns
(Also includes information about FILESTREAM operations using the adapter)
Executing stored procedures
Executing stored procedures with single parameters without using a BizTalk orchestration
Executing stored procedures that contain a FOR XML clause in the definition
Performing composite operations on SQL Server
Invoking scalar functions in SQL Server
Invoking table-valued functions in SQL Server
Performing ExecuteReader, ExecuteScalar, or ExecuteNonQuery operations
Receiving polling-based data-change messages
Receiving SQL Server notifications
The topics in this section provide information, procedures, and examples to help you develop applications that consume the SQL adapter in both BizTalk Server and .NET programming solutions. The topics also provide information on other key aspects of using the adapters such as:
- Connecting to SQL Server.
- Retrieving metadata from SQL Server.
- Using binding properties to configure the adapter.
- Establishing a Connection to SQL Server
- Retrieving Metadata for SQL Server Operations in Visual Studio
- Working with BizTalk Adapter for SQL Server Binding Properties
- Before Developing Applications Using the SQL Adapter
- Developing BizTalk Applications
- Developing Applications by Using the WCF Service Model
- Developing Applications by Using the WCF Channel Model
- How Do I?