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

Using the ADPDataReader

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

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;OAuthClientId=YourClientId;OAuthClientSecret=YourClientSecret;SSLClientCert='c:\\cert.pfx';SSLClientCertPassword='admin@123'";

using (ADPConnection connection = new ADPConnection(connectionString)) {
  ADPCommand cmd = new ADPCommand("SELECT * FROM Workers", connection);
  
  ADPDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;OAuthClientId=YourClientId;OAuthClientSecret=YourClientSecret;SSLClientCert='c:\\cert.pfx';SSLClientCertPassword='admin@123'"

Using connection As New ADPConnection(connectionString)
  Dim cmd As New ADPCommand("SELECT * FROM Workers", connection)

  Dim rdr As ADPDataReader = cmd.ExecuteReader()

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