system.transaction and webservice confusion, please help

ODP.NET 10.2.0.2.20 does in fact make use of
System.Transactions.

 

http://www.oracle.com/technology/tech/windows/odpne
t/faq.html

 

 

  _____  

From: ambrogiogmail.com [mailto:ambrogiogmail.com] On Behalf Of J. Ambrose
Little
Sent: Tuesday, August 15, 2006 8:44 AM
To: aspnet-architectureaspadvice.com
Subject: [aspnet-architecture] Re: system.transaction and
webservice
confusion, please help

 

No, System.Transactions only handles ADO.NET provider
transactions, and the
providers have to be written to do so.  The only ones I know
participate in
System.Transactions are those provided by Microsoft in the
box.  Last I
heard, Oracle's latest ODP.NET provider still doesn't. 
Not sure about other
providers--you'd have to ask them.

 

But it doesn't may in-memory object changes or things like
WS calls
transactional.  

 

--Ambrose
 

On 8/15/06, Michal Tesar <michal.tesargmail.com> wrote: 

Hi All,

I have a question.

Let's say in my BLL I have a method that will do 5 tasks.

task 1
call internal DAL to do something with internal data, ie
insert into our
database.

task 2 call a webservice and execute a method

..etc.

I wrap this into system.transaction functionality.

If any of these above steps fails, all the tasks will be
rolled back? What
about the webservice call?

What if I'll update something through the webservice, and
it's proceeded OK,
and in the next step I'll udpate my own database, and the
steps fails, I 
need the to have all of the steps failed.

Thank you,
Mike



Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com 
<http://regexadvice.com>
 
Need XML Advice? http://xmladvice.com


Need SQL Advice? http://sqladvice.com Need
RegEx Advice?
http://regexadvice.com
Need XML Advice? http://xmladvice.com




Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com