As you will remember from Chapter 1, generating the schemas and binding files for the operations you intend to use in your project is one of the major steps enabling consumption of the ASDK-based adapters in BizTalk applications. The tool of choice for this task is the Consume Adapter Service wizard, a design-time tool offered by ASDK. To call the wizard we have to right-click Visual Studio project, select Add..., and then Add Generated Items…. In the Add Generated Items windows we need to select Consume Adapter Service and click Add. Once the Consume Adapter Service window shows up, the very first step is to specify the appropriate binding. The ASDK SQL adapter is represented by the sqlBinding—this is what you have to choose in the Select a binding drop down list before performing other operations in the Consume Adapter Service wizard.
Then, after selecting the binding, we click the Configure button to open the Configure Adapter window to specify...