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

[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.

 

[Miha Markic [MVP C#]]

Can't you create a global method that returns properly initialized command?

 

[tom.herz]

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,

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.- Hide quoted text -

- Show quoted text -

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.