VistaDB 6
VistaDB.Provider Namespace / VistaDBCommand Class
Properties Methods Events


In This Topic
    VistaDBCommand Class Members
    In This Topic

    The following tables list the members exposed by VistaDBCommand.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded.   
    Top
    Public Properties
     NameDescription
    Public PropertyOverridden. Gets or sets the text command to run against the data source. Gets or sets the text command to run against the data source.  
    Public PropertyOverridden. Gets or sets the wait time before terminating the attempt to execute a command and generating an error. Gets or sets the time to wait in seconds before stopping a command execution. This is not used in the current engine, but will be used in a future version.  
    Public PropertyOverridden. Indicates or specifies how the System.Data.Common.DbCommand.CommandText property is interpreted. Indicates or specifies how the CommandText property is interpreted. VistaDB supports only Text and StoredProcedures command types.  
    Public PropertyGets or sets the VistaDBConnection used by this VistaDBCommand.  
    Public Property (Inherited from System.ComponentModel.Component)
    Public PropertyOverridden. Gets or sets a value indicating whether the command object should be visible in a customized interface control. This property is not intended to be used in your code. It is used internally to support the designers.  
    Public PropertyTrue if command has DDL commands  
    Public PropertyGets the collection of VistaDBParameter objects.  
    Public Property (Inherited from System.ComponentModel.Component)
    Public PropertyGets or sets the VistaDBTransaction within which this VistaDBCommand object executes.  
    Public PropertyOverridden. Gets or sets how command results are applied to the System.Data.DataRow when used by the Update method of a System.Data.Common.DbDataAdapter. Gets or sets how command results are applied to the DataRow when used by the Update method of a VistaDBDataAdapter.  
    Top
    Protected Properties
     NameDescription
    Protected Property (Inherited from System.ComponentModel.Component)
    Protected PropertyOverridden. Gets or sets the System.Data.Common.DbConnection used by this System.Data.Common.DbCommand.  
    Protected PropertyOverridden. Gets the collection of System.Data.Common.DbParameter objects.  
    Protected PropertyOverridden. Gets or sets the System.Data.Common.DbCommand.DbTransaction within which this System.Data.Common.DbCommand object executes.  
    Protected Property (Inherited from System.ComponentModel.Component)
    Protected Property (Inherited from System.ComponentModel.Component)
    Top
    Public Methods
     NameDescription
    Public MethodOverridden. Attempts to cancels the execution of a System.Data.Common.DbCommand. Attempts to cancel the execution of a query, if no query is running this call does nothing. Cancel will also cause the VistaDBDataReader object to discard any unread rows.  
    Public MethodCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject)
    Public MethodCreates a new instance of a VistaDBParameter object.  
    Public MethodOverloaded. Overridden. Dispose the object - then call the base object to tell it to release as well  
    Public MethodOverridden. Executes a SQL statement against a connection object. Executes a SQL statement against a connection object.  
    Public MethodOverloaded. An asynchronous version of System.Data.Common.DbCommand.ExecuteNonQuery, which executes a SQL statement against a connection object. Invokes System.Data.Common.DbCommand.ExecuteNonQueryAsync(System.Threading.CancellationToken) with CancellationToken.None. (Inherited from System.Data.Common.DbCommand)
    Public MethodOverloaded. Executes the CommandText against the Connection, and returns a VistaDBDataReader.  
    Public MethodOverloaded. Executes the CommandText against the Connection, and returns a VistaDBDataReader, asynchronously.  
    Public MethodOverridden. Executes the query and returns the first column of the first row in the result set returned by the query. All other columns and rows are ignored. Executes the query and returns the first column of the first row in the result set returned by the query. All other columns and rows are ignored.  
    Public MethodOverloaded. An asynchronous version of System.Data.Common.DbCommand.ExecuteScalar, which executes the query and returns the first column of the first row in the result set returned by the query. All other columns and rows are ignored. Invokes System.Data.Common.DbCommand.ExecuteScalarAsync(System.Threading.CancellationToken) with CancellationToken.None. (Inherited from System.Data.Common.DbCommand)
    Public MethodRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodOverridden. Creates a prepared (or compiled) version of the command on the data source. Creates a prepared version of the command on the data source.  
    Public MethodResets the CommandTimeout to its default value.  
    Public Method (Inherited from System.ComponentModel.Component)
    Top
    Protected Methods
     NameDescription
    Protected MethodOverridden. Creates a new instance of a System.Data.Common.DbParameter object.  
    Protected MethodOverridden. Executes the command text against the connection.  
    Protected MethodOverridden. Providers should implement this method to provide a non-default implementation for Overload overloads. The default implementation invokes the synchronous System.Data.Common.DbCommand.ExecuteReader method and returns a completed task, blocking the calling thread. The default implementation will return a cancelled task if passed an already cancelled cancellation token. Exceptions thrown by ExecuteReader will be communicated via the returned Task Exception property. This method accepts a cancellation token that can be used to request the operation to be cancelled early. Implementations may ignore this request.Providers should implement this method to provide a non-default implementation for System.Data.Common.DbCommand.ExecuteReader overloads.The default implementation invokes the synchronous System.Data.Common.DbCommand.ExecuteReader method and returns a completed task, blocking the calling thread. The default implementation will return a cancelled task if passed an already cancelled cancellation token. Exceptions thrown by ExecuteReader will be communicated via the returned Task Exception property. This method accepts a cancellation token that can be used to request the operation to be cancelled early. Implementations may ignore this request.  
    Protected Method (Inherited from System.ComponentModel.Component)
    Protected Method (Inherited from System.ComponentModel.Component)
    Protected MethodOverloaded. Creates a shallow copy of the current System.MarshalByRefObject object. (Inherited from System.MarshalByRefObject)
    Top
    Public Events
     NameDescription
    Public Event (Inherited from System.ComponentModel.Component)
    Top
    See Also