choice of sql adater or a .net component ?
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > BizTalk Server > BizTalk Server Orchestration > choice of sql adater or a .net component ?




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    choice of sql adater or a .net component ?  
medhanush


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
03-07-06 10:51 PM

Hi Gurus,

To update database from orchestraion,

there are two ways, use sql adapter, or call a .net component,
going thru adapter requires, create schema, port binding
going thru .net component doesn't require above 2 steps and eases from
maintenance and doesn't introduce any new issues,
methods in component require static, if not serializable.

can somebody advise me on, is going thur .net component is a better choice ?
and is it that, when 10 orchestratins running, 10 .net components are
created in above scenario ?

TIA
Kishore








[ Post a follow-up to this message ]



    Re: choice of sql adater or a .net component ?  
Eric Stott


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
03-07-06 10:51 PM

We have used both .Net components and functionality built into BizTalk.
Reasons:
.Net
Had to call Stored Procs inside a map that was driven by a repeating node
in the data
BizTalk Orchestration
Error Handling built in
Ability to easily promote through different enviornments

I would recommend using functionality in BizTalk as much as possible, for
supportability.

"medhanush" <medhanush@discussions.microsoft.com> wrote in message
news:F3521ACA-1610-48B3-B351-1D47A4DB84E0@microsoft.com...
> Hi Gurus,
>
> To update database from orchestraion,
>
> there are two ways, use sql adapter, or call a .net component,
> going thru adapter requires, create schema, port binding
> going thru .net component doesn't require above 2 steps and eases from
> maintenance and doesn't introduce any new issues,
> methods in component require static, if not serializable.
>
> can somebody advise me on, is going thur .net component is a better choice
> ?
> and is it that, when 10 orchestratins running, 10 .net components are
> created in above scenario ?
>
> TIA
> Kishore
>
>
>







[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 02:12 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register