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

Using the ExactOnlineDataReader

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

C#

string connectionString = "InitiateOAuth=GETANDREFRESH;Region='United States';Division=5512;";

using (ExactOnlineConnection connection = new ExactOnlineConnection(connectionString)) {
  ExactOnlineCommand cmd = new ExactOnlineCommand("SELECT * FROM Accounts", connection);
  
  ExactOnlineDataReader 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;Region='United States';Division=5512;"

Using connection As New ExactOnlineConnection(connectionString)
  Dim cmd As New ExactOnlineCommand("SELECT * FROM Accounts", connection)

  Dim rdr As ExactOnlineDataReader = cmd.ExecuteReader()

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