Setting Command Timeout globally in Asp.Net / windows applications...

  • Thread starter Thread starter tom.herz
  • Start date Start date
T

tom.herz

Hi,

I've been tasked with the following:

We need to add elements to app.config and web.config to be able to
specify the CommandTimeout for SQL Commands. Since there is no option
in the connection string to set this property globally, this means
that every time we execute an SQL command we will need to set the
CommandTimeout property on the object.

It might be worth looking at implementing a ServiceRegistry to replace
the current multiple places where we allocate connections.


Any help on this issue would be greatly appreciated.
 
Can't you create a global method that returns properly initialized command?
 
Can't you create a global method that returns properly initialized command?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & developmentwww.rthand.com
Blog:http://cs.rthand.com/blogs/blog_with_righthand/




Hi,
Click to expand...
I've been tasked with the following:
Click to expand...
We need to add elements to app.config and web.config to be able to
specify the CommandTimeout for SQL Commands. Since there is no option
in the connection string to set this property globally, this means
that every time we execute an SQL command we will need to set the
CommandTimeout property on the object.
Click to expand...
It might be worth looking at implementing a ServiceRegistry to replace
the current multiple places where we allocate connections.
Click to expand...
Any help on this issue would be greatly appreciated.- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Hi,

That would be the ticket, but I don't know how to do it. Can you
please supply a bit of sample code? It would be MUCH appreciated.

Thanks.
 
Back
Top