dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlCommand Class
Properties Methods Events

PgSqlCommand Class Members

The following tables list the members exposed by PgSqlCommand.

Public Constructors
 NameDescription
Public ConstructorOverloaded. Initializes a new instance of the PgSqlCommand class.  
Top
Public Properties
 NameDescription
Public PropertyOverridden. Gets or sets the SQL statement to execute against PostgreSQL.  
Public PropertyOverridden. Gets or sets the wait time before terminating an attempt to execute a command and generating an error. Note that it is the time to wait for any server reply since the command was sent to a server, and it doesn't include the time necessary to fetch data if the command selects some data.  
Public PropertyOverridden. Gets or sets a value indicating how the CommandText property is to be interpreted.  
Public PropertyGets or sets the PgSqlConnection used by this instance of the PgSqlCommand.  
Public Property (Inherited from System.ComponentModel.Component)
Public PropertyGets or sets a value indicating whether the PgSqlDataReader object will request data from the server on execution ExecuteReader method.  
Public PropertyGets or sets the number of rows that will be transferred across the network at a time if FetchAll is set to false.  
Public PropertyReturns the object ID generated for an OID column by the previous insert command.  
Public PropertyGets or sets a form or other container that the Devart.Common.DbCommandBase instance belongs to. (Inherited from Devart.Common.DbCommandBase)
Public PropertyGets or sets a value indicating whether the command object regenerates parameter objects if text of the command is changed. (Inherited from Devart.Common.DbCommandBase)
Public PropertyGets or sets the PgSqlParameterCollection.  
Public Property (Inherited from System.ComponentModel.Component)
Public PropertyDetermines how the host to connect to is selected from the list when multiple hosts are specified in the Host connection string parameter of the command connection. See Load Balancing and Failover for more information.  
Public Property (Inherited from System.Data.Common.DbCommand)
Public PropertyDetermines if 'simple query' sub-protocol is applied for executing SQL statements without preparing on server side.  
Public PropertyGets or sets how command results are applied to the System.Data.DataRow when used by the System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) method of the System.Data.Common.DbDataAdapter. (Inherited from Devart.Common.DbCommandBase)
Top
Public Methods
 NameDescription
Public MethodOverloaded. Starts an asynchronous invocation of an ExecuteNonQuery method. (Inherited from Devart.Common.DbCommandBase)
Public MethodOverloaded. Starts an asynchronous invocation of an System.Data.Common.DbCommand.ExecuteReader method. (Inherited from Devart.Common.DbCommandBase)
Public MethodOverridden. Attempts to cancel the execution of the PgSqlCommand.  
Public MethodCreates a new object that is a copy of the current PgSqlCommand instance.  
Public Method (Inherited from System.MarshalByRefObject)
Public MethodCreates a new instance of a PgSqlParameter object.  
Public Method (Inherited from System.ComponentModel.Component)
Public MethodEnds an asynchronous invocation of the ExecuteNonQuery method. (Inherited from Devart.Common.DbCommandBase)
Public MethodEnds an asynchronous invocation of the ExecuteReader method.  
Public MethodExecutes SQL statement against the System.Data.Common.DbCommand.Connection and returns the number of rows affected. (Inherited from Devart.Common.DbCommandBase)
Public MethodReturns a specific subset of rows when paging through the results of a query.  
Public MethodOverloaded. Sends the CommandText to the Connection and builds a PgSqlDataReader.  
Public MethodExecutes 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. (Inherited from Devart.Common.DbCommandBase)
Public Method (Inherited from System.MarshalByRefObject)
Public MethodReturns count of records in the resultset. (Inherited from Devart.Common.DbCommandBase)
Public Method (Inherited from System.MarshalByRefObject)
Public MethodOverridden. Creates a prepared (or compiled) version of the command on the server.  
Public Method (Inherited from Devart.Common.DbCommandBase)
Public MethodResets CommandTimeout to its default value, which is taken from DefaultCommandTimeout. (Inherited from Devart.Common.DbCommandBase)
Public Method (Inherited from System.ComponentModel.Component)
Top
Public Events
 NameDescription
Public Event (Inherited from System.ComponentModel.Component)
Top
See Also