Step 1: Create the Request Message for Insert Operation on Purchase_Order Table

Time to complete: 10 minutes

Objective: In this step, you add a C# class library project to your solution. This library creates an in-memory request message for the Insert operation on the Purchase_Order table. In later steps, the orchestration sends this message to SQL Server to insert records in the table.

Prerequisites

You must have completed the steps in Lesson 3: Execute a Stored Procedure to Select New Employees Added.

To create a request message for Insert operation

1. Add a Visual C# class library project to your solution. For the name of the project, type UpdatePOMessageCreator.

2. Rename Class1.cs to UpdatePOMessageCreator.cs.

3. Copy the following code to the .cs file:

   using System;  
   using System.Collections.Generic;  
   using System.Text;  
   using System.Xml;  
   using System.IO;  
   
   namespace UpdatePOMessageCreator  
   {  
       public class UpdatePOMessageCreator  
       {  
           private static XmlDocument Message;  
           private static string XmlFileLocation;  
           private static string ResponseDoc;  
   
           public static XmlDocument XMLMessageCreator()  
           {  
               XmlFileLocation = "C:\\TestLocation\\CreatePOMessage";  
               try  
               {  
                   ResponseDoc = (Directory.GetFiles(XmlFileLocation, "*.xml", SearchOption.TopDirectoryOnly))[0];  
               }  
               catch (Exception ex)  
               {  
                   Console.WriteLine("Trying to get XML from: " + XmlFileLocation);  
                   Console.WriteLine("EXCEPTION: " + ex.ToString());  
                   throw ex;  
               }  
   
               //Create Message From XML  
               Message = new XmlDocument();  
   
               Message.PreserveWhitespace = true;  
   
               Message.Load(ResponseDoc);  
   
               return Message;  
           }  
       }  
   }  
   
   

   This code snippet expects a request message for the Insert operation on the Purchase_Order table to be present at C:\TestLocation\CreatePOMessage. The code uses the request message to create a similar request message at run time.

4. Add a strong-name key file to the project. For instructions on creating a strong-name key file, see Prerequisites to create SQL applications using the SQL adapter.

   1. In the Solution Explorer, right-click the UpdatePOMessageCreator project and click Properties.

   2. In the Property window, click Signing.

   3. In the Signing tab, select the Sign the assembly check box.

   4. From the Choose a strong-name key file list, click <Browse>.

   5. Navigate to the folder where you created the strong-name key file, and then click Open.

   6. Click Save on the Standard menu bar. Close the Property window.

5. Build the project. Right-click the project and click Build.

6. Add a reference of this project to the BizTalk project in the solution.

   1. In the Solution Explorer, expand the BizTalk project, right-click References, and then click Add Reference.

   2. In the Add Reference dialog box, click the Projects tab.

   3. From the list of project names, select UpdatePOMessageCreator, click Add, and then click OK.

7. Building the project creates the assembly DLL under \bin\Debug folder of the project. You must add this DLL to the Global Assembly Cache (GAC).

   1. Start a Visual Studio Command Prompt.

   2. From the command prompt, navigate to the \bin\Debug\ folder of the UpdatePOMessageCreator project.

   3. Run the following command on the command prompt:

      gacutil /i UpdatePOMessageCreator.dll  
      

What did I just do?

In this step, you added an UpdatePOMessageCreator class library project that creates request message at run-time. You added the reference to this project in the BizTalk project and also added the assembly DLL to the GAC.

Next Steps

You map the response message for the UPDATE_EMPLOYEE stored procedure to the request message for the Insert operation on Purchaser_Order table.

See Also

Step 2: Map the UPDATE_EMPLOYEE Response Message to Insert Operation Request Message
Lesson 4: Perform an Insert Operation on the Purchase Order Table