using wcf-sql adapter

Question

I need to poll the data in xml format and map it to the EDI 834.........

I have written the stored procedure using for xml auto,element

when i consume it using add adapter metadata i am getting a xml message....

but i need to use this xml message to map it to the EDI834 ....How to get the structure of xml so that i can use that in map....

I also followed http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/6a7e0093-0692-4ba5-9e14-0d2090c2cf54

this thread and generated the schems using xml polling and mapped that to EDI834.

But when i use the map into outbound map...It doesnt map the polling data to edi 834..

Answer 1

The WCF-SQL adapter removes the need to use the 'for xml auto, elements' syntax. This is a legacy leftover from the old Sql Adapter.

Just write your stored procedure in a manner to return a consistent result set, then generate metadata against the stored procedure. The adapter framework will create an appropriate schema based on the metadata returned from your stored procedure.

Then simply map the data from your WCF-SQL schema to your EDI834 schema.