Export (0) Print
Expand All

DbCommand Methods

The DbCommand type exposes the following members.

  Name Description
Public method Cancel Attempts to cancels the execution of a DbCommand.
Protected method CreateDbParameter Creates a new instance of a DbParameter object.
Public method CreateObjRef Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.)
Public method CreateParameter Creates a new instance of a DbParameter object.
Public method Dispose() Releases all resources used by the Component. (Inherited from Component.)
Protected method Dispose(Boolean) Releases the unmanaged resources used by the Component and optionally releases the managed resources. (Inherited from Component.)
Public method Equals(Object) Determines whether the specified object is equal to the current object. (Inherited from Object.)
Protected method ExecuteDbDataReader Executes the command text against the connection.
Protected method ExecuteDbDataReaderAsync Providers should implement this method to provide a non-default implementation for ExecuteReader overloads.The default implementation invokes the synchronous 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.
Public method ExecuteNonQuery Executes a SQL statement against a connection object.
Public method ExecuteNonQueryAsync() An asynchronous version of ExecuteNonQuery, which executes a SQL statement against a connection object.Invokes ExecuteNonQueryAsync with CancellationToken.None.
Public method ExecuteNonQueryAsync(CancellationToken) This is the asynchronous version of ExecuteNonQuery. Providers should override with an appropriate implementation. The cancellation token may optionally be ignored.The default implementation invokes the synchronous ExecuteNonQuery 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 ExecuteNonQuery will be communicated via the returned Task Exception property.Do not invoke other methods and properties of the DbCommand object until the returned Task is complete.
Public method ExecuteReader() Executes the CommandText against the Connection, and returns an DbDataReader.
Public method ExecuteReader(CommandBehavior) Executes the CommandText against the Connection, and returns an DbDataReader using one of the CommandBehavior values.
Public method ExecuteReaderAsync() An asynchronous version of ExecuteReader, which executes the CommandText against the Connection and returns a DbDataReader.Invokes ExecuteDbDataReaderAsync with CancellationToken.None.
Public method ExecuteReaderAsync(CancellationToken) An asynchronous version of ExecuteReader, which executes the CommandText against the Connection and returns a DbDataReader. This method propagates a notification that operations should be canceled.Invokes ExecuteDbDataReaderAsync.
Public method ExecuteReaderAsync(CommandBehavior) An asynchronous version of ExecuteReader, which executes the CommandText against the Connection and returns a DbDataReader.Invokes ExecuteDbDataReaderAsync.
Public method ExecuteReaderAsync(CommandBehavior, CancellationToken) Invokes ExecuteDbDataReaderAsync.
Public method ExecuteScalar 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 method ExecuteScalarAsync() An asynchronous version of 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 ExecuteScalarAsync with CancellationToken.None.
Public method ExecuteScalarAsync(CancellationToken) This is the asynchronous version of ExecuteScalar. Providers should override with an appropriate implementation. The cancellation token may optionally be ignored.The default implementation invokes the synchronous ExecuteScalar 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 ExecuteScalar will be communicated via the returned Task Exception property.Do not invoke other methods and properties of the DbCommand object until the returned Task is complete.
Protected method Finalize Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection. (Inherited from Component.)
Public method GetHashCode Serves as the default hash function. (Inherited from Object.)
Public method GetLifetimeService Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Protected method GetService Returns an object that represents a service provided by the Component or by its Container. (Inherited from Component.)
Public method GetType Gets the Type of the current instance. (Inherited from Object.)
Public method InitializeLifetimeService Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Protected method MemberwiseClone() Creates a shallow copy of the current Object. (Inherited from Object.)
Protected method MemberwiseClone(Boolean) Creates a shallow copy of the current MarshalByRefObject object. (Inherited from MarshalByRefObject.)
Public method Prepare Creates a prepared (or compiled) version of the command on the data source.
Public method ToString Returns a String containing the name of the Component, if any. This method should not be overridden. (Inherited from Component.)

In XNA Framework 3.0, this member is inherited from Object.ToString().
Top

  Name Description
Explicit interface implemetation Private method IDbCommand.CreateParameter Creates a new instance of an IDbDataParameter object.
Explicit interface implemetation Private method IDbCommand.ExecuteReader() Executes the CommandText against the Connection and builds an IDataReader.
Explicit interface implemetation Private method IDbCommand.ExecuteReader(CommandBehavior) Executes the CommandText against the Connection, and builds an IDataReader using one of the CommandBehavior values.
Top
Show:
© 2014 Microsoft