Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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

© 2014 Microsoft Corporation. All rights reserved.
Show:
© 2015 Microsoft