| Author |
Transaction based DB updates
|
|
| ee@ee.demon.co.uk 2006-04-27, 7:26 am |
| Hi all,
How do Biztalk developers normally handle multiple DB updates from within
..net components that are being called from a Biztalk orchestration?
Receive PO
|
Expression Update SQL Via .Net Method call
|
Expression Update SQL Via another .Net Method call
|
Stop
I need to be able to rollback the transaction preformed in the earlier
stages.
Surly someone in this news group knows the best way of handing multiple DB
updates from within .net components that are being called from a Biztalk
orchestration?
The problem with putting into a store procedure is that all of the
visibility of the process is lost, i.e. I might as well use DTS!
Thanks in advance
Simon
| |
| Matt Milner 2006-04-27, 7:26 am |
| You can wrap your .NET code into serviced components and then take advantage
of the atomic scope shape in the orchestration. This will enroll your
orchestration state persistence and the serviced component code into a
single transaction.
matt
<ee@ee.demon.co.uk> wrote in message
news:444e7f60$0$8021$c3e8da3@news.astraweb.com...
> Hi all,
>
> How do Biztalk developers normally handle multiple DB updates from within
> .net components that are being called from a Biztalk orchestration?
>
> Receive PO
> |
> Expression Update SQL Via .Net Method call
> |
> Expression Update SQL Via another .Net Method call
> |
> Stop
>
> I need to be able to rollback the transaction preformed in the earlier
> stages.
>
> Surly someone in this news group knows the best way of handing multiple DB
> updates from within .net components that are being called from a Biztalk
> orchestration?
>
> The problem with putting into a store procedure is that all of the
> visibility of the process is lost, i.e. I might as well use DTS!
>
>
> Thanks in advance
>
> Simon
| |
| ee@ee.demon.co.uk 2006-04-27, 7:26 am |
|
On 26-Apr-2006, "Matt Milner" <matt.milner@m3technologypartners dot com>
wrote:
Thanks matt.
Have you actually used this technique?
Do you know where I could find a example.
Thanks in advanced
Simon
| |
| ee@ee.demon.co.uk 2006-04-27, 7:26 am |
|
On 26-Apr-2006, "Matt Milner" <matt.milner@m3technologypartners dot com>
wrote:
Thanks matt.
I was sure someone must know how to implement transactions in this scenario.
Would you go about it this way?
I am tying to sell the use of Biztalk as appose to the current DTS so the
orchestrations need to be quite visual, i.e. I cannot just locate all the
functionality into a stored procedure.
Have you actually used this technique?
Do you know where I could find a example.
Thanks in advanced
Simon
| |
| ee@ee.demon.co.uk 2006-04-27, 7:20 pm |
| Thanks
I was sure someone must know how to implement transactions in this scenario.
Would you go about it this way?
I am tying to sell the use of Biztalk as appose to the current DTS so the
orchestrations need to be quite visual, i.e. I cannot just locate all the
functionality into a stored procedure.
Have you actually used this technique?
Thanks in advanced
Simon
| |
| Matt Milner 2006-04-29, 1:19 am |
| I'm traveling right now, but will try to post a bit more this weekend or
early next week with a sample if possible.
Matt
<ee@ee.demon.co.uk> wrote in message
news:44506678$0$32067$c3e8da3@news.astraweb.com...
>
> On 26-Apr-2006, "Matt Milner" <matt.milner@m3technologypartners dot com>
> wrote:
>
> Thanks matt.
>
> I was sure someone must know how to implement transactions in this
> scenario.
>
> Would you go about it this way?
>
> I am tying to sell the use of Biztalk as appose to the current DTS so the
> orchestrations need to be quite visual, i.e. I cannot just locate all the
> functionality into a stored procedure.
>
> Have you actually used this technique?
>
> Do you know where I could find a example.
>
> Thanks in advanced
>
> Simon
| |
| Madhup 2006-05-29, 5:21 pm |
| Hi Simon
I am facing a similar problem. The only difference is that my COM+
Components and Database Servers are in different domain. I am using the
atomic transaction and trying to pass this to Serviced Components but it is
failing.
Your help to resolve this problem will be highly appreciated.
Thanks in advance
Madhup.
"ee@ee.demon.co.uk" wrote:
> Thanks
>
> I was sure someone must know how to implement transactions in this scenario.
>
> Would you go about it this way?
>
> I am tying to sell the use of Biztalk as appose to the current DTS so the
> orchestrations need to be quite visual, i.e. I cannot just locate all the
> functionality into a stored procedure.
>
> Have you actually used this technique?
>
>
> Thanks in advanced
>
> Simon
>
|
|
|
|