WCF-SQL Strongly Typed Schemas that are generated for Polling vs Request/Response

Question

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"?

Thanks,
Neal Walters
http://NealWalters.com

Answer 1

Hi Neal,

Currently, I'm trying to involve someone familiar with this topic for help. Thank you for your patience.

Regards.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail]. Microsoft One Code Framework

Answer 2

Ok, thanks.  I've got it working via the map I mentioned.  I'm surprised no one has blogged about this before.

Neal

Answer 3

Glad to see you have solved the issue :)

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail]. Microsoft One Code Framework

Answer 4

Hi Neal,

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.

---

Sincerely,

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.