Share via

BizTalk Server: How WCF-SQL Adapter TypedPolling Namespace Is Defined

  • Article

Scenario

This article assumes the reader has knowledge and understanding of BizTalk Server Development. For more information regarding BizTalk Server Development please see the "See Also" section below.

When data is polled from a database source using the WCF-SQL adapter configured for TypedPolling inbound operation type, this data will be strongly typed, and the type will be defined by a schema commonly created using the "Consume Adapter Service" wizard reached by adding a generated item to a BizTalk Project in Visual Studio.

How WCF-SQL InboudID connection property affects the polled data

When multiple receive locations in the same BizTalk Application poll from the same database the WCF-SQL Endpoint address URI must specify an InboundID to be made unique.

This InboundID connection property will be appended to the default namespace http://schemas.microsoft.com/Sql/2008/05/TypedPolling of the TypedPolling message being received by the receive location. 

InboundID and TypedPolling message examples

For an Address URI as this:

mssql://mySqlServer//myDatabase?InboundId=myInboundID

The polled message will be as this:

<TypedPolling xmlns="http://schemas.microsoft.com/Sql/2008/05/TypedPolling/myInboundID">
  <TypedPollingResultSet0>
    <TypedPollingResultSet0>
      <myDataField>myData</myDataField>
    </TypedPollingResultSet0>
  </TypedPollingResultSet0>
</TypedPolling>

See Also

Another important place to find an extensive amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is BizTalk Server Resources on the TechNet Wiki.