none
WCF SQL, difference between "Add Adapter Metadata" and "Consume Adapter Service". RRS feed

  • Question

  • All,

    Finally we are using the WCF SQL Adapter , while playing with it, we found out that we could use both "Add Adapter Metadata" and "Consume Adapter Service", where one of them creates orchestration and multi part messages, where as the the other one creates a binding file.

    When is the best practise use the "Add Adapter Metadata" or "Consume Adapter Service". and what are the advantages and disadvatages...

    • Moved by Ben Cline1Moderator Thursday, May 19, 2011 1:44 PM related to adapters (From:BizTalk Server General)
    Wednesday, May 18, 2011 12:14 PM

Answers

  • Technically speaking, Add Adapter Metadata Wizard and Consume Adapter Service plug-in provide technically the same functionality, when it comes to the Adapter Pack. Consume Adapter Service plug-in is installed by the BizTalk Adapter Pack while the Add Adapter Metadata is part of BizTalk Dev Tools installation. Here's some reasoning why we have two tools that essentially do the same thing, which is to generate metadata for LOB operations.

    In the first release of BizTalk Adapter Pack, users could only use the Consume Adapter Service to generate metadata on LOB operations. Also, because the adapters in the Adapter Pack were only custom bindings for the WCF-Custom adapter so they were not listed explicitly on the BizTalk Server Admin Console.

    In the next version of the BizTalk Adapter Pack, to address some customer needs, an option was introduced to explicitly add the WCF-Custom based LOB adapter to the Admin Console. See Adding the SQL Adapter to BizTalk Server Administration Console. Now when the adapters could be listed on the Admin Console, it was only an extension that users could also use the Add Adapter Metadata wizarrd to generate the metadata for LOB operations (http://msdn.microsoft.com/en-us/library/dd787904(BTS.10).aspx).

     


    ______ Nitin Mehrotra, BizTalk Server CCxG, http://blogs.msdn.com/nitinme/
    Saturday, May 21, 2011 5:19 AM

All replies

  • The Consume Adapter Service BizTalk Project Add-in is available in BizTalk Server projects and is installed as part of the WCF LOB Adapter SDK installation. You use the Consume Adapter Service Add-in to generate message schemas (XSDs) for operations that you want to target in your BizTalk solution. For more information about developing solutions with BizTalk Server, see Developing BizTalk Applications.

    The Add Adapter Metadata Wizard is available in the BizTalk Server projects and is installed as part of the BizTalk Server installation. You use the Add Adapter Metadata Wizard to generate message schemas (XSDs) for operations that you want to target in your BizTalk solution. For more information about developing solutions with BizTalk Server, see Developing BizTalk Applications.

    For more read Connecting to SQL Server in Visual Studio, Connecting to SQL Server in Visual Studio Using Consume Adapter Service Add-in and How Does the Adapter Surface SQL Server Metadata?
    Abdul Rafay - MVP & MCTS BizTalk Server
    blog: http://abdulrafaysbiztalk.wordpress.com/
    Please indicate "Mark as Answer" if this post has answered the question.
    Wednesday, May 18, 2011 12:22 PM
  • Technically speaking, Add Adapter Metadata Wizard and Consume Adapter Service plug-in provide technically the same functionality, when it comes to the Adapter Pack. Consume Adapter Service plug-in is installed by the BizTalk Adapter Pack while the Add Adapter Metadata is part of BizTalk Dev Tools installation. Here's some reasoning why we have two tools that essentially do the same thing, which is to generate metadata for LOB operations.

    In the first release of BizTalk Adapter Pack, users could only use the Consume Adapter Service to generate metadata on LOB operations. Also, because the adapters in the Adapter Pack were only custom bindings for the WCF-Custom adapter so they were not listed explicitly on the BizTalk Server Admin Console.

    In the next version of the BizTalk Adapter Pack, to address some customer needs, an option was introduced to explicitly add the WCF-Custom based LOB adapter to the Admin Console. See Adding the SQL Adapter to BizTalk Server Administration Console. Now when the adapters could be listed on the Admin Console, it was only an extension that users could also use the Add Adapter Metadata wizarrd to generate the metadata for LOB operations (http://msdn.microsoft.com/en-us/library/dd787904(BTS.10).aspx).

     


    ______ Nitin Mehrotra, BizTalk Server CCxG, http://blogs.msdn.com/nitinme/
    Saturday, May 21, 2011 5:19 AM