ExecuteSync()

Use the ExecuteSync() method to run the command object. This method runs synchronously and blocks the engine thread.

Syntax

result ExecuteSync( )

Remarks

Use the ExecutionState and LastExecutionError properties to check for status of this method.

After ExecuteSync() is processed you can still obtain a reference to the command object and analyze its ExecutionState and LastError properties.

Use the LastExecutionError property to check if the command failed or succeeded (success is indicated by a blank string), since ExecuteSync() may return 0 in the case of a failure instead of an error message.

To free all resources allocated for the command object, you must call Dispose().