Develop SQL applications using the WCF Channel Model

You can use the Windows Communication Foundation (WCF) channel model to consume the Microsoft BizTalk Adapter for SQL Server by sending XML messages directly over a channel instance created with the SQL Server Binding.

One advantage of using the WCF channel model over using the strongly-typed classes and methods that the WCF service model exposes is that the channel model provides more fine-grained control over the operations that you perform on the SQL database. This control comes from the fact that in the WCF channel model, you directly control the contents of the messages that you send over the channel.

In certain scenarios, this extra level of control can be beneficial. For example, when you use the WCF channel model to perform an Update operation on a table, you can selectively update columns in the target rows by omitting columns from the update template that you pass in the message. The only columns that are required are those with “nillable=false” in the WSDL. The update method exposed by a WCF client uses a strongly-typed record parameter for the template that includes every column in the table schema.

The sections in this topic explain how to perform operations on the SQL adapter by using the WCF channel model.

In This Section

• Overview of the WCF channel model with the SQL adapter

• Create a channel using the SQL adapter

• Run an Insert Operation on a Table in SQL using the WCF Channel Model

• Receive Polling-based Data-changed Messages from SQL Server by Using the WCF Channel Model

See Also

Develop your SQL applications