PgSqlAttributeCollection Class

In This Topic

Represents collection of PgSqlAttribute objects.

Syntax

Visual Basic
C#

'Declaration
 
Public NotInheritable Class PgSqlAttributeCollection 
   Inherits System.Collections.CollectionBase
   Implements System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.IList

public sealed class PgSqlAttributeCollection : System.Collections.CollectionBase, System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.IList

Remarks

PgSqlAttributeCollection can be retrieved using PgSqlRowType.Attributes property. The collection is read-only.

For information on how to use PgSqlAttributeCollection with composite types refer to article Working with Composite Types.

Example

This sample demonstrates usage of PgSqlRow, PgSqlRowType, PgSqlAttribute, and PgSqlAttributeCollection classes. It retrieves data from a column of composite type in a table and renders the data to console. To run the samples successfully you have to create server objects with the following script: CREATE TYPE tperson AS (name text, age integer); CREATE TABLE personnel (id integer, person tperson);

csharp

static void ReadData(PgSqlConnection conn)  
{ 
  string str = "SELECT person FROM personnel"; 
  PgSqlCommand pgCommand = new PgSqlCommand(str,conn); 
  PgSqlDataReader pgReader = pgCommand.ExecuteReader(); 
  while (pgReader.Read())  
  { 
    //obtain data
    PgSqlRow pgRow = pgReader.GetPgSqlRow(0);
    if (pgRow == null) 
    {
      Console.WriteLine();
      continue;
    }
    //obtain data description
    PgSqlRowType pgRowType = pgRow.RowType;
    //iterate through all columns
    foreach(PgSqlAttribute pgAttr in pgRowType.Attributes)
    {
      Console.Write(pgRow[pgAttr] + "\t"); 
    }
    Console.WriteLine();
  } 
  pgReader.Close(); 
}

Visual Basic

Sub ReadData(ByVal conn As PgSqlConnection)
  Dim str As String = "SELECT person FROM personnel"
  Dim pgCommand As PgSqlCommand = New PgSqlCommand(str, conn)
  Dim pgReader As PgSqlDataReader = pgCommand.ExecuteReader()
  While pgReader.Read()
    'obtain data
    Dim pgRow As PgSqlRow = pgReader.GetPgSqlRow(0)
    If pgRow Is Nothing Then
      Console.WriteLine()
    Else
      'obtain data description
      Dim pgRowType As PgSqlRowType = pgRow.RowType
      'iterate through all columns
      For Each pgAttr As PgSqlAttribute In pgRowType.Attributes
        Console.Write(pgRow(pgAttr) & Chr(9))
      Next pgAttr
      Console.WriteLine()
    End If
  End While
  pgReader.Close()
End Sub

Inheritance Hierarchy

System.Object
System.Collections.CollectionBase
Devart.Data.PostgreSql.PgSqlAttributeCollection

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

Reference

PgSqlAttributeCollection Members
Devart.Data.PostgreSql Namespace
PgSqlAttribute Class
PgSqlRowType Class

Send Feedback