TransactionScope: lightweight or distributed transaction
Posted: Fri 05 Mar 2010 16:02
Hi,
I have a question about the use of System.Transactions.TransactionScope:
does it create a distributed transaction or a lightweight transaction? What happens if multiple connections are opened (in the scope) to the same Oracle server?
For instance:
I would assume that the transaction remains local (lightweight)?
Thanks in advance for your answer,
Deefken
I have a question about the use of System.Transactions.TransactionScope:
does it create a distributed transaction or a lightweight transaction? What happens if multiple connections are opened (in the scope) to the same Oracle server?
For instance:
Code: Select all
Using txScope As New TransactionScope()
Using conn As New OracleConnection("Data Source=SOMESERVER;...")
conn.Open()
Using conn2 As New OracleConnection("Data Source=SOMESERVER;...")
conn.Open()
conn.Close()
End Using
conn.Close()
End Using
End Using
Thanks in advance for your answer,
Deefken