Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SqlCE - CommandTimeout
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 2.0
Miscellaneous
Thread ID:
01231602
Message ID:
01232098
Views:
19
Kevin,

You are right, CommandTimeout is always zero with SqlCE. When I step through the framework code, I get to the code:

public virtual object ExecScalar(IDbCommand command)
{
object Scalar;
command.CommandTimeout = this.CommandTimeout;

in the mmDataAccessBase class. When this code attempts to execute, an exception is thrown since SqlCE will not allow CommandTimeout to be changed. It is zero when I arrive at this code, but the framework's base class is attempting to set it to 30. Let me know what you think.

Thanks,

Mat



>Mat,
>
>It looks like the SqlCE command object supports the CommandTimeout property, it's just that it's always set to zero. I recommend setting the CommandTimeout variable in your SqlCe class to zero (you can set it in the constructor) and see if that helps.
>
>Best Regards,
Matthew Kennedy
Decision Support Technology Inc.

"I try to take one day at a time, but sometimes several days attack me all at once." ~ Ashleigh Brilliant

New Jersey Dot Net User Group
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform