Connection Property (PgSqlCommand)

In This Topic

Syntax
Remarks
Example
See Also

Gets or sets the PgSqlConnection used by this instance of the PgSqlCommand.

Syntax

Visual Basic
C#

public new PgSqlConnection Connection {get; set;}

'Declaration
 
Public Shadows Property Connection As PgSqlConnection

Property Value

The connection to a data source. The default value is a null reference.

Remarks

PgSqlConnection specified in this property will carry out all operations executed with this PgSqlCommand.

This property supports the InterForm technology.

A single PgSqlConnection can be used by many PgSqlCommand objects on the assumption that all operations will be done consecutively. In other words, you can not execute an SQL statement while an asynchronous operation is in progress.

Example

The following example creates a PgSqlCommand and sets some of its properties.

csharp

public void CreateCommand()
{
  string mySelectQuery = "SELECT * FROM Test.Dept ORDER BY DeptNo";
  PgSqlCommand pgCommand = new PgSqlCommand(mySelectQuery);
  pgCommand.Connection = new PgSqlConnection(
    "host=server;database=test;user id=postgres;");
  pgCommand.CommandType = System.Data.CommandType.Text;
}

Visual Basic

Public Sub CreateCommand()
  Dim mySelectQuery As String = _
    "SELECT * FROM Test.Dept ORDER BY DeptNo"
  Dim pgCommand As New PgSqlCommand(mySelectQuery)
  pgCommand.Connection = New PgSqlConnection( _
    "host=server;database=test;user id=postgres;")
  pgCommand.CommandType = System.Data.CommandType.Text
End Sub

Reference

PgSqlCommand Class
PgSqlCommand Members
CommandText Property
CommandType Property

Send Feedback