Trouble with Transation timeouts
Posted: Fri 16 Jul 2010 13:51
Hi,
I have been having trouble with the following code. I am trying to a large transaction over a slow connection that takes approximately 35 minutes to run. I end up getting a Transaction timeout error when I do the oScope.complete. Seems to me like I set the timeout to 1 hour+ but I'm still getting a timeout. Any ideas?
Thanks ... Ed
I have been having trouble with the following code. I am trying to a large transaction over a slow connection that takes approximately 35 minutes to run. I end up getting a Transaction timeout error when I do the oScope.complete. Seems to me like I set the timeout to 1 hour+ but I'm still getting a timeout. Any ideas?
Thanks ... Ed
Code: Select all
Using oScope As New TransactionScope TransactionScopeOption.Required, New TimeSpan(1, 1, 1))
Dim db As New MyDataContext
' do stuff
db.SubmitChanges()
oScope.Complete()
End Using