Updategram with SQL-adapter into WCF-SQL adapter solution. RRS feed

  • Question

  • 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.












    If I generate schemas with the Consume Adapter service I get a schema with multiple roots, one for each table.








    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.

    Tuesday, May 1, 2012 6:54 PM


  • Hi,

    Check this similar thread and also check the composite operations here. Hope this helps

    MCTS: BizTalk Server 2010,BizTalk Server 2006 and WCF
    My Blog:dpsbali-biztalkweblog
    Mark As Answer or Vote As Helpful if this helps.

    • Proposed as answer by Ankur11 Wednesday, May 2, 2012 7:01 AM
    • Marked as answer by LeoTangModerator Wednesday, May 9, 2012 10:02 AM
    Wednesday, May 2, 2012 5:40 AM