BizTalk xml to composite SQL operations

1. Add generated item

2.Manually create composite schema

3.Create messages, mapping and logic ports

4.Deploy and configure physical ports

Note:

The schema must have two root nodes: one named Request and another named RequestResponse. The namespace of the schema must be in the format of http://[PROJECT_ NAME].[COMPOSITE_SCHEMA_NAME], In order to reuse our adapter-generated schemas, we must use the Import option and reference both generated schemas.

New SOA Capabilities in BizTalk Server 2009: WCF SQL Server Adapter

http://www.packtpub.com/article/soa-capabilities-in-bizTalk-wcf

Note:

We need to add an additional entry here, which reflects our composite operation. The new entry is:

<Operation Name="InsertComposite" Action="CompositeOperation" />

The operation Name must match the orchestration's logical port name, while the Action value must always be equal to CompositeOperation in order for the adapter to correctly process it.

Why does the Adapter say ‘Action is not understood’ even though I am using the binding file generated by the ‘Consume Adapter Service’ wizard?

http://blogs.msdn.com/b/biztalk_adapter_development/archive/2008/01/08/why-does-the-adapter-say-action-is-not-understood-even-though-i-am-using-the-binding-file-generated-by-the-consume-adapter-service-wizard.aspx