Command Time Out when executing stored procedures VIA Data Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the Microsoft Data Access Application Block for .NET v2 to run
stored procedures with the ExecuteDataset, ExecuteScaler and ExecuteReader
functions. Some of my stored procedures take longer than 30 seconds to run
and I am getting time out errors in my application.

Why was the ability to specify a command time out not part of this class? Is
this in version 3 of the block? What would be the best way to add the ability
to set the CommandTimeOut for this class?

Thanks,

Matthew
 
Add a property to the application block or just add an augmented method.
You have the code so you can do with it as you please. We have tons of
augmentation we've done with it to fit out needs - that's the nice part of
having the code. You can do it internally or use a config setting or just
add some new overloads to it.
 
Back
Top