none
Need some details RRS feed

  • Question

  • Hi,
    Can you please show me the steps to create this?
    <?xml version="1.0" encoding="utf-8" ?>
    <RequestResponse xmlns="http://CompositeTest.CompositeSchema">
      <InsertResponse xmlns="http://schemas.microsoft.com/Sql/2008/05/TableOp/dbo/Employee">
        <InsertResult>
          <long xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays">10080</long>
        </InsertResult>
      </InsertResponse>
      <GET_LAST_EMP_DATAResponse xmlns="http://schemas.microsoft.com/Sql/2008/05/Procedures/dbo">
        <GET_LAST_EMP_DATAResult>
          <DataSet xmlns="http://schemas.datacontract.org/2004/07/System.Data">
            <xs:schema id="NewDataSet" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
              <xs:element msdata:IsDataSet="true" name="NewDataSet">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element minOccurs="0" maxOccurs="unbounded" name="NewTable">
                      <xs:complexType>
                        <xs:sequence>
                          <xs:element minOccurs="0" name="Employee_ID" type="xs:int" />
                          <xs:element minOccurs="0" name="Name" type="xs:string" />
                          <xs:element minOccurs="0" name="DOJ" type="xs:dateTime" />
                          <xs:element minOccurs="0" name="Designation" type="xs:string" />
                          <xs:element minOccurs="0" name="Job_Description" type="xs:string" />
                          <xs:element minOccurs="0" name="Photo" type="xs:base64Binary" />
                          <xs:element minOccurs="0" name="Rating" type="xs:string" />
                          <xs:element minOccurs="0" name="Salary" type="xs:decimal" />
                          <xs:element minOccurs="0" name="Last_Modified" type="xs:base64Binary" />
                        </xs:sequence>
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
            </xs:schema>
            <diffgr:diffgram xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
              <NewDataSet xmlns="">
                <NewTable>
                  <Employee_ID>10080</Employee_ID>
                  <Name>John</Name>
                  <Designation>Manager</Designation>
                  <Salary>100000.00</Salary>
                  <Last_Modified>AAAAAAAAF40=</Last_Modified>
                </NewTable>
              </NewDataSet>
            </diffgr:diffgram>
          </DataSet>
        </GET_LAST_EMP_DATAResult>
        <ReturnValue>0</ReturnValue>
      </GET_LAST_EMP_DATAResponse>
      <DeleteResponse xmlns="http://schemas.microsoft.com/Sql/2008/05/TableOp/dbo/Employee">
        <DeleteResult>1</DeleteResult>
      </DeleteResponse>
    </RequestResponse>

    Many Thanks & Best Regards, Hua Min

    Friday, October 19, 2012 9:20 AM

All replies

  • Hi Hua Min,

    Based on my understanding, you are following a sample for biztalk wcf-sql adapter. Could you please elaborate which sample you are following? Based on my experience, there should also be a readme file included in the sample, have you tried following the instructions of the readme?

    Thanks.


    Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact msdnmg@microsoft.com. Microsoft One Code Framework

    Monday, October 22, 2012 7:23 AM
    Moderator