Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SqlCE - CommandTimeout
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Environment:
C# 2.0
Divers
Thread ID:
01231602
Message ID:
01232098
Vues:
18
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform