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

Using the LakebaseDataReader

The LakebaseDataReader retrieves data faster than the LakebaseDataAdapter because it can retrieve data in pages. As you read data from the LakebaseDataReader, 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 "lakebase"."schema01".Orders table:

C#

string connectionString = "User=lakebase;Password=admin;Database=lakebase;Server=127.0.0.1;Port=5432";

using (LakebaseConnection connection = new LakebaseConnection(connectionString)) {
  LakebaseCommand cmd = new LakebaseCommand("SELECT * FROM \"lakebase\".\"schema01\".Orders", connection);
  
  LakebaseDataReader 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=lakebase;Password=admin;Database=lakebase;Server=127.0.0.1;Port=5432"

Using connection As New LakebaseConnection(connectionString)
  Dim cmd As New LakebaseCommand("SELECT * FROM \"lakebase\".\"schema01\".Orders", connection)

  Dim rdr As LakebaseDataReader = cmd.ExecuteReader()

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