none
WCF SQl Insert Strong Type procedure into sql? RRS feed

  • Question

  • 1. I have genrated Strong type schema for inserting product into sql via Storeprocedure  using WCF SQl.

    2. I have created Receive Schema with gicen detail 
    <products>
        <product>
             <number/>
             <name/>
             <UOM/>
             <Unit/>
         </product>
     </products>

    Then I mapped this with strong type auto genrated schema
    Source Schema                Deatination Schema
    Products
        Product      map with      AddProduct
            number  map with      number
            name     map with      name
            uom      map with      uom
            unit       map with      unit

     I have small issue, I am using xml as receive input file
    Same products schema conating multiple products, however while processing this only inserting first node. Any idea how to insert allnode into databse using wcf sql strong type store procedure.

    I followed this link http://connectedthoughts.wordpress.com/2009/06/29/using-the-biztalk-wcf-sql-adapter-to-load-a-flat-file-into-a-sql-server-2008-table/#comment-1171 
    only diffrence is I am using xml as input type.

     


    Rit
    • Moved by Ben Cline1Moderator Thursday, June 16, 2011 1:50 AM Related to adapters (From:BizTalk Server General)
    Thursday, June 16, 2011 12:02 AM

Answers