dotConnect for PostgreSQL Documentation
PgSqlCommand Class Members
See Also  Properties  Methods  Events support@devart.com
Devart.Data.PostgreSql Namespace : PgSqlCommand Class


The following tables list the members exposed by PgSqlCommand.

Public Constructors

 NameDescription
public ConstructorPgSqlCommand ConstructorOverloaded. Initializes a new instance of the PgSqlCommand class.  
Top

Public Properties

 NameDescription
public PropertyCommandTextOverridden. Gets or sets the SQL statement to execute against PostgreSQL.  
public PropertyCommandTimeoutOverridden. 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 PropertyCommandTypeOverridden. Gets or sets a value indicating how the CommandText property is to be interpreted.  
public PropertyConnectionGets or sets the PgSqlConnection used by this instance of the PgSqlCommand.  
public PropertyContainerGets the System.ComponentModel.IContainer that contains the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
public PropertyFetchAllGets or sets a value indicating whether the PgSqlDataReader object will request data from the server on execution ExecuteReader method.  
public PropertyFetchSizeGets or sets the number of rows that will be transferred across the network at a time if FetchAll is set to false.  
public PropertyInsertOidReturns the object ID generated for an OID column by the previous insert command.  
public PropertyOwnerGets or sets a form or other container that the Devart.Common.DbCommandBase instance belongs to. (Inherited from Devart.Common.DbCommandBase)
public PropertyParameterCheckGets 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 PropertyParametersGets or sets the Devart.Data.PostgreSql.PgSqlParameterCollection.  
public PropertySiteGets or sets the System.ComponentModel.ISite of the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
public PropertyTargetSessionDetermines 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 PropertyTransactionGets or sets the System.Data.Common.DbTransaction within which this System.Data.Common.DbCommand object executes. (Inherited from System.Data.Common.DbCommand)
public PropertyUnpreparedExecuteDetermines if 'simple query' sub-protocol is applied for executing SQL statements without preparing on server side.  
public PropertyUpdatedRowSourceGets or sets how command results are applied to the System.Data.DataRow when used by the Update method of a System.Data.Common.DbDataAdapter. (Inherited from System.Data.Common.DbCommand)
Top

Public Methods

 NameDescription
public MethodBeginExecuteNonQueryOverloaded. Starts an asynchronous invocation of an Devart.Common.DbCommandBase.ExecuteNonQuery method. (Inherited from Devart.Common.DbCommandBase)
public MethodBeginExecuteReaderOverloaded. Starts an asynchronous invocation of an System.Data.Common.DbCommand.ExecuteReader method. (Inherited from Devart.Common.DbCommandBase)
public MethodCancelOverridden. Attempts to cancel the execution of the PgSqlCommand.  
public MethodCloneCreates a new object that is a copy of the current PgSqlCommand instance.  
public MethodCreateObjRefCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject)
public MethodCreateParameterCreates a new instance of a Devart.Data.PostgreSql.PgSqlParameter object.  
public MethodDisposeReleases all resources used by the System.ComponentModel.Component. (Inherited from System.ComponentModel.Component)
public MethodEndExecuteNonQueryEnds an asynchronous invocation of the Devart.Common.DbCommandBase.ExecuteNonQuery method. (Inherited from Devart.Common.DbCommandBase)
public MethodEndExecuteReaderEnds an asynchronous invocation of the ExecuteReader method.  
public MethodExecuteNonQueryExecutes a SQL statement against a connection object. (Inherited from System.Data.Common.DbCommand)
public MethodExecutePageReaderReturns a specific subset of rows when paging through the results of a query.  
public MethodExecuteReaderOverloaded. Sends the CommandText to the Connection and builds a PgSqlDataReader.  
public MethodExecuteScalarExecutes 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. (Inherited from System.Data.Common.DbCommand)
public MethodGetLifetimeServiceRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
public MethodGetRecordCountReturns count of records in the resultset. (Inherited from Devart.Common.DbCommandBase)
public MethodInitializeLifetimeServiceObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
public MethodPrepareOverridden. Creates a prepared (or compiled) version of the command on the server.  
public MethodResetCommandTimeoutResets Devart.Common.DbCommandBase.CommandTimeout to its default value, which is taken from Devart.Common.DbCommandBase.DefaultCommandTimeout. (Inherited from Devart.Common.DbCommandBase)
Top

Public Events

 NameDescription
public EventDisposedOccurs when the component is disposed by a call to the System.ComponentModel.Component.Dispose method. (Inherited from System.ComponentModel.Component)
Top

See Also