Also, just as a clarification to an earlier point made:
System.Transactions
does much more than just handling ADO.NET provider
transactions as stated in
an earlier post. While the post was contextually accurate
(System.Transactions couldn't solve the
webservice-participating-in-a-transaction problem without
the webservice
being transactionally aware), System.Transactions does allow
code to be
transactionified, and it also supplies automatic escalation
from lightweight
local transactions through heavier weight MSDTC transactions
(see:
http://msdn2.microsoft.com/en-us/library/system
.transactions.aspx).
System.Transactions could potentially be used as an element
of his solution.
--Paul
-----Original Message-----
From: Steven M. Swafford [mailto:steven.swafford gmail.com]
Sent: Tuesday, August 15, 2006 11:54 AM
To: aspnet-architectureaspadvice.com
Subject: [aspnet-architecture] Re: 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
Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com
|