Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Sql Adapter query › Re: Sql Adapter query
June 9, 2009 at 12:31 AM
#22613
Hi.
You can add another public receive-send port(Web). you will recieve the input message from the web page through this public port(Web), get your result from another port(SQL) and send your SQL result to through the former public port(Web).
After you have deployed this orchestration, you will then have to expose you orchestration as a web service.
Add this web service reference on your web application so you can invoke it ans get the results onto your page.