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.
Connection | Overloaded. Gets or sets the NpgsqlConnection used by this instance of the NpgsqlCommand.
Container (inherited from Component) |
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.
Parameters | Overloaded. Gets the NpgsqlParameterCollection.
Site (inherited from Component) |
Transaction | Overloaded. 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 connection 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.
ExecuteReader | Overloaded. 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) |

#### Protected Instance Properties

DesignMode (inherited from Component) |
Events (inherited from Component) |

#### See Also

NpgsqlCommand Class | Npgsql Namespace