Home Page › Forums › BizTalk 2004 – BizTalk 2010 › how to construct the initial select message? › Re: how to construct the initial select message?
[quote user="lberan"]I typed xDoc.LoadXml(“……”); in the expression of Message Assignment shape within the construct shape. Is it correct?[/quote]
Yes, that’s right.
[quote user="lberan"]Is it the message in the Messages folder on Orchestration view?[/quote]
In that folder – you define your messages (every message must be or XmlDocument, or in your case – type of request schema)
[quote user="lberan"]where can I add those lines? [/quote]
In a Construct shape. Actually – to build Xml instance you can also in an Expression shape, but for learning purposes that’s OK with Construct shape too.
I have built a sample – for you to see how it should look. I put a rar file, within you will find a solution, a script for table and stored procedure, and a binding. For running this sample ( if you want to run it – deploy solution, after it deployed – go to administration console, right click on an application – import binding – let the binding file for WCF port to be created – you need two folders in and out on your C:\temp directory). If you have some test DB – create with that scripts table and a stored procedures, and fill table with some data. To run the sample you put the xml “Instance” to “In” folder and in out will appear the data from created table.
Download sample http://uploading.com/files/76ma5c8d/SelectTest.rar/
If you need some additional help – write here. :))