dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlConnection Class / CreateCommand Method
Example

CreateCommand Method (PgSqlConnection)
Creates and returns a PgSqlCommand object associated with the PgSqlConnection.
Creates and returns a PgSqlCommand object associated with the PgSqlConnection.
Syntax
'Declaration
 
Public Shadows Function CreateCommand() As PgSqlCommand
 

Return Value

A PgSqlCommand object.
Remarks
You can use this method as an alternative to common PgSqlCommand constructors.
Example
In this sample PgSqlCommand object is created. It is automatically associated with PgSqlConnection that created it.
public void CreatePgSqlCommand(string myConnString)
{
  PgSqlConnection pgConnection = new PgSqlConnection(myConnString);
  PgSqlCommand pgCommand = pgConnection.CreateCommand();
  pgCommand.CommandText = "INSERT INTO DEPT VALUES (50,'Development','Philadelphia')";
  pgConnection.Open();
  try
  {
    pgCommand.ExecuteNonQuery();
  }
  finally
  {
    pgConnection.Close();
  }
}
Public Sub CreatePgSqlCommand(ByVal myConnString As String)
  Dim pgConnection As New PgSqlConnection(myConnString)
  Dim pgCommand As PgSqlCommand = pgConnection.CreateCommand()
  pgCommand.CommandText = "INSERT INTO DEPT VALUES (50,'Development','Philadelphia')"
  pgConnection.Open()
  Try
    pgCommand.ExecuteNonQuery()
  Finally
    pgConnection.Close()
  End Try
End Sub
See Also