Npgsql Api Docs

NpgsqlCommand Members

NpgsqlCommand overview

Public Instance Constructors

NpgsqlCommand Overloaded. Initializes a new instance of the NpgsqlCommand class.

Public Instance Properties

CommandText Gets or sets the SQL statement or function (stored procedure) to execute at the data source.
CommandTimeout Gets or sets the wait time before terminating the attempt to execute a command and generating an error.
CommandType Gets or sets a value indicating how the CommandText property is to be interpreted.
ConnectionOverloaded. Gets or sets the NpgsqlConnection used by this instance of the NpgsqlCommand.
Container 
DesignTimeVisible 
LastInsertedOID Returns oid of inserted row. This is only updated when using executenonQuery and when command inserts just a single row. If table is created without oids, this will always be 0.
ParametersOverloaded. Gets the NpgsqlParameterCollection.
Site 
TransactionOverloaded. Gets or sets the NpgsqlTransaction within which the NpgsqlCommand executes.
UpdatedRowSource Gets or sets how command results are applied to the DataRow when used by the Update method of the DbDataAdapter.

Public Instance Methods

Cancel Attempts to cancel the execution of a NpgsqlCommand.
Clone Create a new command based on this one.
CreateObjRef (inherited from MarshalByRefObject) 
CreateParameter Creates a new instance of a NpgsqlParameter object.
Dispose (inherited from Component) 
Equals (inherited from Object) 
ExecuteNonQuery Executes a SQL statement against the connection and returns the number of rows affected.
ExecuteReaderOverloaded. Sends the CommandText to the Connection and builds a NpgsqlDataReader.
ExecuteScalar Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.
GetHashCode (inherited from Object) 
GetLifetimeService (inherited from MarshalByRefObject) 
GetType (inherited from Object) 
InitializeLifetimeService (inherited from MarshalByRefObject) 
Prepare Creates a prepared version of the command on a PostgreSQL server.
ToString (inherited from Component) 

Public Instance Events

Disposed (inherited from Component) 

See Also

NpgsqlCommand Class | Npgsql Namespace