Command Time Out when executing stored procedures VIA Data Access

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
 
W

W.G. Ryan eMVP

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top