Anyone using the DataAccess application block from microsoft?
Just wondering if there was a creative way to set the connection timeout besides going into the block and overloading methods to take a timeout value.
Thanks
Printable View
Anyone using the DataAccess application block from microsoft?
Just wondering if there was a creative way to set the connection timeout besides going into the block and overloading methods to take a timeout value.
Thanks
I think if you want to set it with each call, you will have to modify the procedures to accept this new argument.
Is there a reason why the default isn't good enough?
I think the default is 30 seconds or so - and I have one query in particular that takes a minute + to complete - so for that query I need to set the timeout to 2 minutes.
That was the answer I was afraid of. I guess the end product will be more flexible in the long run though :D