does WCFSQL adapeter supports returing mutiple result sets returened from Stored procedure RRS feed

  • Question

  • Hi

    I have a scenario- from BizTalk i need to call stored procedure.s 

    GetOrderDetailsByOrderId  stored procedure returns the order details and list of line item details for that order.

    This Stored Procedure i want to consume in BizTalk. Does BizTalk support retrieving records from database.

    Wednesday, October 21, 2015 6:00 PM


  • Yes ,You can get multiple result set depending on what your sql stored procedure is returning as an output .

    When you run through the WCF- SQL schema wizard it generates xsd schema for the resultant set instead of single row of data . So you don't need to worry much about this .BizTalk WCF SQL adapter internally manages it .



    • Marked as answer by Ammu_Biz Friday, October 23, 2015 5:15 PM
    Thursday, October 22, 2015 6:38 AM
  • YES, it does.

    Just run the metadata Wizard against that Stored Procedure and you'll see there will be two result sets under the response node.

    Wednesday, October 21, 2015 6:55 PM

All replies