InsertOid Property

On this page

Returns the object ID generated for an OID column by the previous insert command.

Syntax

Visual Basic
C#


'Declaration Public ReadOnly Property InsertOid As Long


public long InsertOid {get;}

Property Value

The ID generated for an OID column.

Remarks

Use InsertOid property after you have performed an INSERT command into a table.

If the command doesn't perform an insertion into a table the value of InsertOid won't be defined.

Example

After running the query the value assigned to OID column for the inserted record is shown.

csharp


static void GetLastId(PgSqlConnection pgConnection) { PgSqlCommand pgCommand = new PgSqlCommand("INSERT INTO Test.Dept (DeptNo, DName, Loc) VALUES (Null, 'AnotherOne', 'SomeWhere')", pgConnection); pgConnection.Open(); try { pgCommand.ExecuteNonQuery(); Console.WriteLine(pgCommand.InsertOid); } finally { pgConnection.Close(); } }

static void GetLastId(PgSqlConnection pgConnection)
{
  PgSqlCommand pgCommand = new PgSqlCommand("INSERT INTO Test.Dept (DeptNo, DName, Loc) VALUES (Null, 'AnotherOne', 'SomeWhere')", pgConnection);
  pgConnection.Open();
  try
  {
    pgCommand.ExecuteNonQuery();
    Console.WriteLine(pgCommand.InsertOid);
  }
  finally
  {
    pgConnection.Close();
  }
}

Visual Basic


Public Sub GetLastId(ByVal pgConnection As PgSqlConnection) Dim pgCommand As New PgSqlCommand("INSERT INTO Test.Dept (DeptNo, DName, Loc) VALUES (Null, 'AnotherOne', 'SomeWhere')", pgConnection) pgConnection.Open() Try pgCommand.ExecuteNonQuery() Console.WriteLine(pgCommand.InsertOid) Finally pgConnection.Close() End Try End Sub

Public Sub GetLastId(ByVal pgConnection As PgSqlConnection)
  Dim pgCommand As New PgSqlCommand("INSERT INTO Test.Dept (DeptNo, DName, Loc) VALUES (Null, 'AnotherOne', 'SomeWhere')", pgConnection)
  pgConnection.Open()
  Try
    pgCommand.ExecuteNonQuery()
    Console.WriteLine(pgCommand.InsertOid)
  Finally
    pgConnection.Close()
  End Try
End Sub

Reference

PgSqlCommand Class
PgSqlCommand Members

Send Feedback