List Info

Thread: system.transaction and webservice confusion, please help




system.transaction and webservice confusion, please help
user name
2006-08-15 13:43:30
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 <gmail.com">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
Need XML Advice? http://xmladvice.com


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

about | contact  Other archives ( Real Estate discussion Medical topics )