none
WCF-SQL Adaptor RRS feed

  • Question

  • Hi All,
    I need little help with WCF-SQL Adaptor.
    I installed and tryin to consume schemas.

    It Created 3 Schemas+ 1 Binding file. (Trying to do insert Operation on Table with multiple records)

    The Schemas created are :
    I_SimpleTypeAyyay.xsd
    I_Table.dbo.xsd
    I_TableOperation.dbo.TableName.xsd

    My question is which schema to use if I am trying to use for multiple rows insert.

    Also in my scenario I get a response from another table with multiple rows and by addition adiitional value from variable to the destinatation insert.

    How do i use the varible can use in Message Assignment.

    For EXAMPLE
    RESPONSE GETTING

    EMPNAME         EMPADD
    MICROSOFT     REDMOND
    AMAZON          SEATTLE


    Varibale (STATE)== WA

    INSERT TO DIFFERENT TABLE (SHOULD LOOK LIKE)
    EMPNAME       EMPADD               EMPSTATE                 ID(AUTO)
    MICROSOFT    REDMOND            WA                           1
    AMAZON         SEATTLE               WA                          2

    Thanks,

    Saturday, July 25, 2009 7:54 PM

Answers

  • Look for for the schema which has "Insert" as it's root node name.

    It should be present in the file - I_TableOperation.dbo.TableName.xsd

    This schema should be used. All other schemas are helper schemas and are never used directly.


    Regarding the second Question, it can be done  using multi-part maps.


    Input Message1                                                   Output Message


    EMPNAME  ----------------------------------->          EMPNAME
    EMPADD   ----------------------------------->          EMPADD
                                  /---------------------->          EMPSTATE
                                 /
    Input message2    /
                             /
                            /
    EMPSTATE -----/
    Monday, July 27, 2009 1:21 PM