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

Using the ZuoraDataReader

The ZuoraDataReader retrieves data faster than the ZuoraDataAdapter because it can retrieve data in pages. As you read data from the ZuoraDataReader, 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 SampleTable_1 table:

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;OAuthClientID=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;Tenant=USProduction;ZuoraService=DataQuery;";

using (ZuoraConnection connection = new ZuoraConnection(connectionString)) {
  ZuoraCommand cmd = new ZuoraCommand("SELECT * FROM SampleTable_1", connection);
  
  ZuoraDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;OAuthClientID=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;Tenant=USProduction;ZuoraService=DataQuery;"

Using connection As New ZuoraConnection(connectionString)
  Dim cmd As New ZuoraCommand("SELECT * FROM SampleTable_1", connection)

  Dim rdr As ZuoraDataReader = cmd.ExecuteReader()

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