This topic has not yet been rated - Rate this topic

Development

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 Basic Insert, Update, Delete, and Select Operations by Using BizTalk Server	Performing Insert, Update, Delete, and Select Operations by Using the WCF Service Model	Performing an Insert Operation on a Table Using the WCF Channel Model
Performing operations on tables and views with large data type columns (Also includes information about FILESTREAM operations using the adapter)	Performing Operations on Tables and Views with Large Data Types by Using BizTalk Server	Performing Operations on Tables and Views with Large Data Types by Using the WCF Service Model	-
Executing stored procedures	Executing Stored Procedures in SQL Server by Using BizTalk Server	Invoking Stored Procedures Using the WCF Service Model	-
Executing stored procedures with single parameters without using a BizTalk orchestration	Executing Stored Procedures With a Single XML Parameter	-	-
Executing stored procedures that contain a FOR XML clause in the definition	Executing Stored Procedures Having a FOR XML Clause	-	-
Performing composite operations on SQL Server	Performing Composite Operations on SQL Server by Using BizTalk Server	-	-
Invoking scalar functions in SQL Server	Invoking Scalar Functions in SQL Server by Using BizTalk Server	Invoking Scalar Functions in SQL Server by Using the WCF Service Model	-
Invoking table-valued functions in SQL Server	Invoking Table-Valued Functions in SQL Server by Using BizTalk Server	Invoking Table-Valued Functions in SQL Server by Using the WCF Service Model	-
Performing ExecuteReader, ExecuteScalar, or ExecuteNonQuery operations	Performing ExecuteReader, ExecuteScalar, or ExecuteNonQuery Operations by Using BizTalk Server	Performing ExecuteReader, ExecuteScalar, or ExecuteNonQuery Operations by Using WCF Service Model	-
Receiving polling-based data-change messages	Polling SQL Server by Using the SQL Adapter with BizTalk Server	Polling SQL Server by Using the SQL Adapter with WCF Service Model	Receiving Polling-based Data-changed Messages from SQL Server by Using the WCF Channel Model
Receiving SQL Server notifications	Receiving Query Notifications by Using BizTalk Server	Receiving Query Notifications Using the WCF Service Model	-

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.

In This Section

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)