Thursday, September 20, 2012 3:35 PM
I'd like to confirm my conclusions.
I have a stored proc called Extract_EFSR. The existing system has 5 different receive locations all using polling in order to begin the extracts. Each one has a different ExtractTypeCode that gets passed.
My new requirement is to call the stored proc with a new parm (InventoryReconciliationId) from an orchestration, so now I'm the world of request/response. I ran through the "Add generated items" and built new the new schema. [I made the new parm optional and set it default value of Null so as to not break existing code.]
The existing system has an XSLT-based map that combines the parent/child relationship into a third schema that follows a more natural hierarchy.
So as to re-use to the best of my ability the existing XSLT code, I will probably create a new map to map the right-side of the above picture to the left side. It seems like an addition step that wouldn't be needed if the polling and request/response result schemas were the same.
1) So I want to verify that indeed, that if a person generates a schema using receive-polling vs request-response, the schemas are quite different.
2) Then a question is, how does the WCF-SQL adapter know what to use for the root and child element names. Why did it choose "StoredProcedureResultSet0"? Can I change that, or I must leave exactly as is?
3) Also, does every schema generated for polling have a root node of "TypedPolling"?
Monday, September 24, 2012 2:31 AMModerator
Monday, September 24, 2012 10:11 PM
Ok, thanks. I've got it working via the map I mentioned. I'm surprised no one has blogged about this before.
- Marked As Answer by Lloyd ZhangMicrosoft Contingent Staff, Moderator Tuesday, September 25, 2012 1:53 AM
Tuesday, September 25, 2012 1:53 AMModerator
Thursday, September 27, 2012 1:50 PM
Here are the answers I was able to get to your questions:
1. Yes, it is both – known and intentional – to make polling and notification operations work as intended. Check answer 3.
2. Not clear on this question but perhaps you can use following properties while creating operations in “Add Generated Items” wizard:
3. Yes. Since this can cause duplicate message types, the recommended approach is to place your polling schemas operations into a different project and create a reference to that project from your other projects.
Randy S. Ridgely [MSFT]
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
This posting is provided “AS IS” with no warranties, and confers no rights. You assume all risk for your use. © 2011 Microsoft Corporation. All rights reserved.