In this section we will cover some of the frequently used operations provided by the ASDK SQL adapter. We prepared a few easy to follow examples that focus on the details of the adapter operations and not on building the entire BizTalk application itself or the details of the SQL Server objects used.
For these examples we have a scenario where sales order details are kept inside a few different tables in a SQL Server database. Scripts to generate database artifacts are provided with the sample code accompanying this chapter.
The three main tables used in the examples are SalesOrderHeader, SalesOrderStatus, and SalesOrderDetails.
The SalesOrderHeader table contains the base information about the order including when it is due, shipped, the Account number, CustomerID, SalesPersonID, and so on:
The SalesOrderStatus table tracks the status of the Order from a systems integration perspective. Since we do not want BizTalk to process orders multiple times, we need to manage...