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

Using the ZohoCreatorDataReader

The ZohoCreatorDataReader retrieves data faster than the ZohoCreatorDataAdapter because it can retrieve data in pages. As you read data from the ZohoCreatorDataReader, 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 [CData].[Employee Management].Leave_Types table:

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;";

using (ZohoCreatorConnection connection = new ZohoCreatorConnection(connectionString)) {
  ZohoCreatorCommand cmd = new ZohoCreatorCommand("SELECT * FROM [CData].[Employee Management].Leave_Types", connection);
  
  ZohoCreatorDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;"

Using connection As New ZohoCreatorConnection(connectionString)
  Dim cmd As New ZohoCreatorCommand("SELECT * FROM [CData].[Employee Management].Leave_Types", connection)

  Dim rdr As ZohoCreatorDataReader = cmd.ExecuteReader()

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