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

Using the ActOnDataReader

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

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:80";

using (ActOnConnection connection = new ActOnConnection(connectionString)) {
  ActOnCommand cmd = new ActOnCommand("SELECT * FROM Images", connection);
  
  ActOnDataReader rdr = cmd.ExecuteReader();

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

VB.NET

Dim connectionString As String = "InitiateOAuth=GETANDREFRESH;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;CallbackURL=http://localhost:80"

Using connection As New ActOnConnection(connectionString)
  Dim cmd As New ActOnCommand("SELECT * FROM Images", connection)

  Dim rdr As ActOnDataReader = cmd.ExecuteReader()

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