dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlDataReader Class / GetGuid Method / GetGuid(Int32) Method
Example

GetGuid(Int32) Method
Gets the value of the specified column as a universally unique identifier (UUID).
Syntax
'Declaration
 
Public Overloads Overrides Function GetGuid( _
   ByVal i As Integer _
) As Guid
 

Parameters

i

Return Value

The value of the specified column.
Example
static void GetMyGuid(PgSqlConnection myConnection) {
  PgSqlCommand cmd = new PgSqlCommand("SELECT * FROM Test.AllTypes");
  cmd.Connection = myConnection;
  myConnection.Open();
  try {
    PgSqlDataReader reader = cmd.ExecuteReader();
    reader.Read();
    Guid recievedGuid = reader.GetGuid(reader.GetOrdinal("GuidCol"));
    reader.Close();
  }
  finally {
    myConnection.Close();
  }
}
Shared Sub GetMyGuid(ByVal myConnection As PgSqlConnection)
  Dim cmd As New PgSqlCommand("SELECT * FROM Test.AllTypes")
  cmd.Connection = myConnection
  myConnection.Open()
  Try
    Dim reader As PgSqlDataReader = cmd.ExecuteReader
    reader.Read()
    Dim recievedGuid As Guid = reader.GetGuid(reader.GetOrdinal("GuidCol"))
    reader.Close()
  Finally
    myConnection.Close()
  End Try
End Sub
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also