NpgsqlCommand Class

Represents a command to be executed against the PostgreSQL database backend.

Syntax

public sealed class NpgsqlCommand : System.ComponentModel.Component, System.Data.IDbCommand, ICloneable

Remarks

An NpgsqlCommand object is associated with a Npgsql.NpgsqlConnection instance.It can be used to execute SQL statements (SELECT, INSERT, UPDATE, DELETE, etc.), stored procedures and functions against the database the Npgsql.NpgsqlConnection instance referenced in the NpgsqlCommand.Connection is associated with.

As the NpgsqlCommand implements the System.Data.IDbCommand interface, it can be used to

Execute queries without expecting a result back using the NpgsqlCommand.ExecuteNonQuery method
Execute queries only a single (scalar) result back using the NpgsqlCommand.ExecuteScalar method
Execute queries without expecting a gsql.NpgsqlDataReader back using the NpgsqlCommand.ExecuteDataReader

Requirements

Namespace: Npgsql
Assembly: Npgsql (in Npgsql.dll)
Assembly Versions: 0.6.0.0, 1.0.5000.0, 2.0.0.0