locked
WCF-SQL adapter RRS feed

  • Question

  • Hi,

    I'm trying to use WCF-SQL adapter to call stored procedures on SQL server.

    I get procedure name from input message and then I try to call that procedure on sql server.

    But I have little problems in doing that. Is it possible to give stored procedure name and parameters dynamically to WCF-SQL adapter to execute it and after that parse its generic response message?

    And if it is, How can it be done?

    Thanks in advance

    Woltor

    Thursday, June 13, 2013 11:32 AM

Answers

  • Since BizTalk 2009, WCF Custom Adapters support Dynamic Ports. So basically you might be able to configure a Dynamic WCF-SQL Send port by referring to following link.

    http://msdn.microsoft.com/en-us/library/dd788439(BTS.10).aspx

    In your case, WCF.Action would be "Procedure/dbo/[SP_Name]".

    Hope this helps.


    Don't forg to mark the post as answer or vote as helpful if it does, Regards - Sathish Krishnan




    Thursday, June 13, 2013 12:12 PM

All replies

  • Since BizTalk 2009, WCF Custom Adapters support Dynamic Ports. So basically you might be able to configure a Dynamic WCF-SQL Send port by referring to following link.

    http://msdn.microsoft.com/en-us/library/dd788439(BTS.10).aspx

    In your case, WCF.Action would be "Procedure/dbo/[SP_Name]".

    Hope this helps.


    Don't forg to mark the post as answer or vote as helpful if it does, Regards - Sathish Krishnan




    Thursday, June 13, 2013 12:12 PM
  • The sp name is actually part of message so you don't really need to use a dynamic port.  Once you map to the Request, that's it.

    What you're asking should just work naturally.  You still have to generate schemas for the individual stored procedure operations though.

    You also have to combine all the Action mappings if you're using only one Send Port.

    Thursday, June 13, 2013 12:41 PM
    Moderator