Currently migrating a Biztalk2006 solution to 2010. In a few orchestrations Im dealing with updategrams. I need to abandon the old SQL adapter and use the WCF-SQL or solve this some other way.
In the current solution I have an updategram that inserts data into three different tables.
ReqRoot
-sync
--before
---Table1
----elements...
---Table2
---Table3
--after
---Table1
---Table2
---Table3
If I generate schemas with the Consume Adapter service I get a schema with multiple roots, one for each table.
-Table1
--elements...
-ArrayOfTable1
-Table2
-ArrayOfTable2
-Table3
-ArrayOfTable3
Is there a way to get all that information into one root so I can use ONE message? Or does this way of solving it require me to make construct three separate messages within the orchestration?
Writing a .net class to solve this?
I want to minimize the changes needed to do in the orchestrations. Also, I cant add stored procedures etc to the database.
