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

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.

Answer 1

Hi Ammu4biz,

Thank you for posting in MSDN forum.

Yes, you can retrieve multiple records using SP. Please use WCF-SQL adapter for the operation.

I would suggest please have a look into below article for some help,

BizTalk Server: WCF-SQL Adapter Table Operations

BizTalk 2010 XML Polling with WCF-SQL Adapter

Insert with WCF-SQL-Adapter BizTalk 2010

BizTalk - simple WCF tutorial for using a stored procedure

BizTalk Server 2010 - Using the WCF-SQL adapter to make multiple stored procedure calls

---

Thanks, If my reply is helpful please mark as answer or vote as helpful.

Answer 2

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.

Answer 3

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 .

Thanks

Abhishek