Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CommandTimeout with ExecScalar
Message
 
À
05/01/2009 20:15:01
Timothy Bryan
Sharpline Consultants
Conroe, Texas, États-Unis
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Environment:
C# 2.0
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01371141
Message ID:
01371300
Vues:
19
>Try stepping all the way through to verify it makes it to the ExecuteScalar() method of SQLCommand object. You have to have the Mere Mortals debug symbols added in order to step into that code or have the framework project added to your solution.
>Tim

Tim,

You are correct, the error is not on the ExecScalar command. I stepped through the framework code and the error is happening in the mmDataAccessBase class on this line:

public virtual object ExecScalar(IDbCommand command)

object Scalar;
command.CommandTimeout = this.CommandTimeout;

They are both of type int and I can see them in the watch window, but if I try to change the value of command.CommandTimeout it throws an execption.

It seems the most likely cause is I have a subclass of mmDataAccess for SqlCE (Compact Edition). I have to test with standard SQL, but I am not sure why this line in the base class is not allowing the change? Your support is very appreciated.

Kind Regards,

Mat
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