none
Entire Message into single column -- WCF-SQL RRS feed

  • Question

  • I have incoming message where it has header and body, Now I need to insert the entire message into one of the field in SQLServer DB using WCF-SQL and also some field from header & body to columns in the DB.
    Please any suggestion
    Thanks.
    Monday, June 20, 2011 2:29 PM

Answers

All replies

  • Hi,

    You can look at this sample and look at how message is inserted in SQL Server and see if logic can help your requirement.


    HTH

    Regards,

    Steef-Jan Wiggers
    MVP & MCTS BizTalk Server
    http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly


    BizTalk
    Monday, June 20, 2011 7:11 PM
    Moderator
  • The xml data type in SQL works very well for this type of scenario. I would call a procedure over WCF-SQL that has a parameter of xml data type.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Monday, June 20, 2011 7:34 PM
    Moderator
  • You may be able use the outbound message body property of the port to format the message for an xml data type with WCF-SQL.

    It is actuallly a lot more common to call a .NET method in an orchestration or custom pipeline component with the XLangMessage/XMLDocument and use this to call a procedure that takes the message as an Xml data type parameter.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Tuesday, June 21, 2011 12:42 AM
    Moderator
  • You might want to have a look at this too: http://msdn.microsoft.com/en-us/library/dd788448(v=BTS.70).aspx
    ______ Nitin Mehrotra, BizTalk Server CCxG, http://blogs.msdn.com/nitinme/
    Wednesday, June 22, 2011 5:30 AM
  • Thanks for pointing the FILESTREAM article out Nitin, I was not aware there was one devoted to that. That would definitely work too, and your approach would also work for non Xml data.

    Thanks,


    If this answers your question, please use the "Answer" button to say so | Ben Cline
    Wednesday, June 22, 2011 2:24 PM
    Moderator