The CData ADO.NET Provider for EnterpriseDB implements two ADO.NET interfaces you can use to retrieve data from EnterpriseDB: EnterpriseDBDataAdapter and EnterpriseDBDataReader objects. Whereas EnterpriseDBDataAdapter objects retrieve a single result set of all the data that matches a query, EnterpriseDBDataReader objects fetch data in subset increments as needed.

Using the EnterpriseDBDataReader

The EnterpriseDBDataReader retrieves data faster than the EnterpriseDBDataAdapter because it can retrieve data in pages. As you read data from the EnterpriseDBDataReader, it periodically requests the next page of results from the data source, if required. This causes results to be returned at a faster rate. The following example selects all the columns from the "postgres"."public".Orders table:

C#

string connectionString = "User=postgres;Password=admin;Database=postgres;Server=127.0.0.1;Port=5444";

using (EnterpriseDBConnection connection = new EnterpriseDBConnection(connectionString)) {
  EnterpriseDBCommand cmd = new EnterpriseDBCommand("SELECT * FROM \"postgres\".\"public\".Orders", connection);
  
  EnterpriseDBDataReader rdr = cmd.ExecuteReader();

  while (rdr.Read()) {
    Console.WriteLine(String.Format("\t{0} --> \t\t{1}", rdr["ShipName"], rdr["ShipCity"]));
  }
}

VB.NET

Dim connectionString As String = "User=postgres;Password=admin;Database=postgres;Server=127.0.0.1;Port=5444"

Using connection As New EnterpriseDBConnection(connectionString)
  Dim cmd As New EnterpriseDBCommand("SELECT * FROM \"postgres\".\"public\".Orders", connection)

  Dim rdr As EnterpriseDBDataReader = cmd.ExecuteReader()

  While rdr.Read()
    Console.WriteLine([String].Format(vbTab & "{0} --> " & vbTab & vbTab & "{1}", rdr("ShipName"), rdr("ShipCity")))
  End While
End Using